Link to home
Start Free TrialLog in
Avatar of piyushdabomb
piyushdabomb

asked on

VBA Inputbox is not letting me select cells...

Hi,

I have a simple input box line that's supposed to let me select cells from a range:

Set rng = Application.InputBox(Prompt:="Select the Range whose formats you want to specify.", Type:=8)

When I run the input box, I can't select any cell from any workbooks or any worksheets and its super annoying. I'm not sure why!

Any ideas here?
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Hi piyushdabomb,

An input box only lets you enter values, not select from a cell

Gary
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of piyushdabomb
piyushdabomb

ASKER

Awesome - thanks!