Show user form, leave wosksheet active

W

Wric Smith

I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated.
 
G

Greg Koppel

Hi Wric,

You have to have at least Excel 2K, and set the ShowModal property of the
userform to false.

Regards, Greg

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
T

Tom Ogilvy

If you have Excel 2000 or later, show your userform as vbModeless

Userform1.Show vbModeless

--
Regards,
Tom Ogilvy

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
W

Wric Smith

Thanks. I just wish I knew enough to know what i'm looking for. You guys are Great!

----- Tom Ogilvy wrote: -----

If you have Excel 2000 or later, show your userform as vbModeless

Userform1.Show vbModeless

--
Regards,
Tom Ogilvy

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
Top