Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Mona Mehta   on Mar 02 In MS Office Category.

  
Question Answered By: Rachel Barnes   on Mar 02

The 'interaction' that Steve is referring to sounds like he used AutoFilter
where it automatically puts little drop down boxes in the header of a table so
the user can select what criteria to sort  the table on. This can be found in the
menu Data/Filter/AutoFilter.

Dawn's "InputBox" is a VBA method for the Application object that queries the
user for a specific type of data  (string, cell  address, etc.) It's not clear
whether Dawn means "inputbox" in the generic sense (like any text field) or the
one from the Application object (only done via VBA code) which has multiple
arguments (only one required).

Public Sub makeBold()
Dim rng As Range

' Type:=8 refers to a cell/range
Set rng = Application.InputBox("Select a cell/s", Type:=8)
rng.Font.Bold = True
Set rng = Nothing
End Sub

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Retain cell selection through sort Or get search suggestion and latest updates.


Tagged: