User form browsing for a range on a sheet?

[Don Wiss]

From what I know about User Forms, once on them you can't get back to the
worksheet. What would be a nice enhancement for a utility I have is to give
the user buttons that would let them browse for a range, and then that
range address being put into a textbox on the form. Possible?

Don <donwiss at panix.com>.

 

[Norman Jones]

Hi Don,

Look at the RefEdit control which should do what you want.

 

[Don Wiss]

Look at the RefEdit control which should do what you want.

I tried it. First I set the modal property of the user form to False. I
added the control. I did a show of the form. I clicked the RefEdit
control's button and the form disppeared. It let me select a range. I then
pressed enter and it wrote the range into the control. But then all was
locked up. I could not close the form. I was unable to type anything on the
worksheet or VBA editor. The only thing that closed the form was Alt-F4.
But then everything was still locked up. What obviously necessary step was
I missing?

Don <donwiss at panix.com>.

 

[Norman Jones]

Hi Don,

According to MSDN article:

http://makeashorterlink.com/?P20B12759

a RefEdit control cannot be used on a modeless userform. The article relates
to xl2k but I cannot speak for the latest xl versions.