Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm shown and worksheet active
Can I have a user form shown and at the same time be able to work on the
worksheet? I want to be able to click on a buttom of the form but at the same time be able to work on the worksheet. Can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm shown and worksheet active
hi
yes you can. a form has 2 modes. modal and modeless. when a form is modal, the user must supply information or close the form before you can work on any other part of excel. even code pauses and waits for input. when the form is modeless, then the form can be displayed but other parts of excel and be accessed. look up the show modal property in vb help. to display the form modeless..... Load frmUserform1 frmUserform1.Show 0 the zero at the end of show displays the form as modeless. Regards FSt1 Alberto Ast" wrote: Can I have a user form shown and at the same time be able to work on the worksheet? I want to be able to click on a buttom of the form but at the same time be able to work on the worksheet. Can this be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm initialize event run when UserForm is shown | Excel Programming | |||
Using Cells while UserForm shown | Excel Programming | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Userform Shown while macro runs | Excel Programming | |||
Viewing a worksheet while a UserForm is active | Excel Programming |