UserForm help

[Michael]

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?

 

[Khai]

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 Korn]

Thanks! I'll check it out.

 

[Harald Staff]

Hi

1) Userform1.Show vbModeless

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

 

[Michael Korn]

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!