Show user form, leave wosksheet active

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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.
 
Back
Top