Thread: UserForm shown and worksheet active
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default UserForm shown and worksheet active

"FSt1" wrote in message
...


Load frmUserform1
frmUserform1.Show 0

the zero at the end of show displays the form as modeless.

Or more logically, use the built-in, descriptive, constants

Load frmUserform1
frmUserform1.Show vbModeless


Reply With QuoteReply With Quote