Excel VBA InputBox Range Selection Button

Question

Ok. So I'm familiar with InputBoxs in VBA to some degree. I'm aware of the Type:=8 requirement to select a range. My code works fine and allows me to do what I want to.

This is what it looks like: enter image description here

However, I want to generate the same type of inputbox that Exel itself generates when selecting a range.

enter image description here

I've been searching through various online resources and the only thing that comes up again and again is that Type:=8 needs to be used. The MS Help has also not been of much help.

For completness' sake here is my code:

Dim SelRng1 As Range
Dim SelRng2 As Range

Set SelRng1 = Application.InputBox(Prompt:="Please select the first table (headers included)", Title:="Select Table 1", Type:=8)
Set SelRng2 = Application.InputBox(Prompt:="Please select the second table (headers included)", Title:="Select Table 1", Type:=8)

Anyone know how to do this? Thanks!

GSerg · Accepted Answer · 2012-12-21 11:59:38Z

3

You have to create your own form and put the RefEdit control on it.

answered Dec 21, 2012 at 11:59

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jon Peltier Over a year ago

Of course, the RefEdit is flaky as anything. I've written an article about using InputBox as an Alternative to Excel's Flaky RefEdit Control. It's not as "nice", but it doesn't crash on 5% of users' machines.

Collectives™ on Stack Overflow

Excel VBA InputBox Range Selection Button

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related