VBA Inputbox is not letting me select cells...

piyushdabomb
piyushdabomb used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi piyushdabomb,

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

Gary
Top Expert 2015
Commented:
Piyush,
You need to set screenupdating to True before you do that as i believe you have set it to false because of which it is not letting you do that, This is what i meant.
Saurabh...

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

Open in new window

Author

Commented:
Awesome - thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial