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
|