I am writing a macro in Excel 2000 to manipulate large
amounts of data. I set at a UserForm to gather required
information on the data to be sorted. Unfortunately, not
all of the information is viewable when the UserForm
shows. Does anybody know how to allow navigation of a
worksheet while a UserForm is showing?

How about when a message box is displayed?

http://www.bmsltd.co.uk/Excel/Default.htm

Check out FormFun.Zip, read it, study it, you'll see. It's not for the
feignt of heart though. =D

-khai

"Michael" wrote in message
...
I am writing a macro in Excel 2000 to manipulate large
amounts of data. I set at a UserForm to gather required
information on the data to be sorted. Unfortunately, not
all of the information is viewable when the UserForm
shows. Does anybody know how to allow navigation of a
worksheet while a UserForm is showing?

How about when a message box is displayed?

Thanks! I'll check it out.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi

1) Userform1.Show vbModeless

2) Can't be done with MsgBox'es, they are always modal and very annoying.

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"Michael" skrev i melding
...
I am writing a macro in Excel 2000 to manipulate large
amounts of data. I set at a UserForm to gather required
information on the data to be sorted. Unfortunately, not
all of the information is viewable when the UserForm
shows. Does anybody know how to allow navigation of a
worksheet while a UserForm is showing?

How about when a message box is displayed?

I tried UserForm1.Show vbModeless. When I ran the code it seemed to skip
over the UserForm, or rather it didn't wait to receive the necessarry
information from the form. It then gave me an error message seemingly
because it was looking for a variable value that hadn't been entered
yet. Maybe I did something wrong; I'll try it again.

Thanks for the advice!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!