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(Promp t:="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?
I have a simple input box line that's supposed to let me select cells from a range:
Set rng = Application.InputBox(Promp
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome - thanks!
An input box only lets you enter values, not select from a cell
Gary