LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Inputbox question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another InputBox question... Phil Excel Discussion (Misc queries) 4 April 12th 07 03:37 PM
inputbox question redb Excel Discussion (Misc queries) 0 October 6th 05 02:57 PM
Inputbox question wilro85[_6_] Excel Programming 5 September 9th 05 03:57 PM
Inputbox Question Joel Mills Excel Programming 6 June 28th 05 10:08 PM
Inputbox question Nancy[_4_] Excel Programming 3 December 12th 03 01:56 AM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"