View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
K_Macd K_Macd is offline
external usenet poster
 
Posts: 54
Default UserForm shown and worksheet active

Note there are behaviour differences. When you reselect a sheet the focus
will still be with the form so you will then need to expressly select the
grid. Also CTRL+F6 to toggle around workbooks will not function if the form
has the focus.

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Bob Phillips" wrote:


"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