Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two questions.
The Set rngActive = Application...line below executes without a problem. I get the inputbox and can select the cell (may be on another worksheet). The rngActive.Select line gives me an error message: Select method or range class failed. If I use a Msgbox to display rngActive after the Set statement, it does not display the inputbox cell address that displayed in the inutbox. Dim rngActive As Range Set rngActive = Application.InputBox(prompt:="Click cell or range", Title:="Cell(s)", Type:=8) rngActive.Select The second question is why does the inputbox syntax below return an error message. I get an error message that select method of range class failed & the Type:=8 causing the error. Why does the Type: statement work in the code above and the one below displays an error? rngActive = InputBox(prompt:="Click cell or range", Title:="Cell(s)", Type:=8) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another InputBox question... | Excel Discussion (Misc queries) | |||
inputbox question | Excel Discussion (Misc queries) | |||
Inputbox question | Excel Programming | |||
Inputbox Question | Excel Programming | |||
Inputbox question | Excel Programming |