| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Hi, I've created a form in VB to add and sort information in Excel. Right now
it doesn't allow any interaction with Excel while using the form. I want to be able to have the form stay open and be able to work in Excel, does anyone know how I would do that? Now, if I want to do anything in Excel I have to close the form first. Thanks, John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Form
Hi,
In the userform properties box set ShowModal to false Mike "johnrb7865" wrote: Hi, I've created a form in VB to add and sort information in Excel. Right now it doesn't allow any interaction with Excel while using the form. I want to be able to have the form stay open and be able to work in Excel, does anyone know how I would do that? Now, if I want to do anything in Excel I have to close the form first. Thanks, John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Form
Private Sub Workbook_Open() UserForm1.Show vbModeless End Sub "johnrb7865" wrote: Hi, I've created a form in VB to add and sort information in Excel. Right now it doesn't allow any interaction with Excel while using the form. I want to be able to have the form stay open and be able to work in Excel, does anyone know how I would do that? Now, if I want to do anything in Excel I have to close the form first. Thanks, John |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Form
Worked perfect.
Thanks, John "Mike H" wrote: Hi, In the userform properties box set ShowModal to false Mike "johnrb7865" wrote: Hi, I've created a form in VB to add and sort information in Excel. Right now it doesn't allow any interaction with Excel while using the form. I want to be able to have the form stay open and be able to work in Excel, does anyone know how I would do that? Now, if I want to do anything in Excel I have to close the form first. Thanks, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
| Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
| Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
| User form ComboBox Items: Remember user entries? | Excel Programming | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
Linear Mode
