Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Upon running the following code I get a message "Compile Error: Object
Required" Sub FQCHECK() Dim FQTEXT As String Set FQTEXT = Application.InputBox(PROMPT:="Insert Keyword", Type:=2) MsgBox ("YOU TYPED " & FQTEXT) End Sub While the following code executes perfectly: Sub FQCHECK() Dim FQRANGE As Range Set FQRANGE = Application.InputBox(PROMPT:="SELECT CELL", Type:=8) MsgBox ("YOU SELECTED " & FQRANGE.Address) End Sub What might be the cause? Is the Set statement only suitable for selection range? Because the first piece of code works fine if entered as: Sub FQCHECK() Dim FQTEXT As String FQTEXT = Application.InputBox(PROMPT:="Insert Keyword", Type:=2) MsgBox ("YOU TYPED " & FQTEXT) End Sub -- Best Regards, FARAZ A. QURESHI |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement with range | Excel Worksheet Functions | |||
IF STATEMENT Range | Excel Discussion (Misc queries) | |||
range in an IF statement | Excel Worksheet Functions | |||
Use a range name in VB with IF Then Else statement | Excel Discussion (Misc queries) | |||
IF Statement with a range | Excel Worksheet Functions |