User form browsing for a range on a sheet?
 

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.

User form browsing for a range on a sheet?
 

Hi Don,

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

---
Regards,
Norman



"Don Wiss" wrote in message
...
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.

User form browsing for a range on a sheet?
 

On Sat, 18 Sep 2004, Norman Jones wrote:

Don Wiss wrote:
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?

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.

User form browsing for a range on a sheet?
 

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.

---
Regards,
Norman



"Don Wiss" wrote in message
...
On Sat, 18 Sep 2004, Norman Jones wrote:

Don Wiss wrote:
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?

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.