| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access to spreadsheets with VBA User Form up
I have a User Form I built in VBA for Excel. When it is active/
displayed, I am unable to display any Excel spreadsheets it has used (still open). Is there a way around this? Thanks, Alan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Access to spreadsheets with VBA User Form up
Do you mean unable to interact, rather than display, spreadsheets?
The default open mode for UserForm.show is Modal, to allow interaction with other objects you need to open it Mode Less. Use something like.... UserForm1.Show (0) -- Regards, Nigel "Alan" wrote in message ... I have a User Form I built in VBA for Excel. When it is active/ displayed, I am unable to display any Excel spreadsheets it has used (still open). Is there a way around this? Thanks, Alan |
| 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 | |||
| Access query feeding spreadsheet control in a user form | 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 | |||
| Browser on a user form? with VB. Excel or Access. | Excel Programming | |||
![Alan[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
