Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading, but not activating userform
I've created a userform that I activate from
'ThisWorkbook' (userform1.show) when I open the file. As I understand the 'show' command, I have to interact with the form before I can work in the spreadsheet. In practice, I can't activate any of the cells, commands, etc until I close the form or select and launch the options on the form. What I'd like to be able to do is launch the file, work in the sheet as if it was a normal excel file, then run the form when required. I can achieve this haphazardly by creating a command button that launches the userform, but I'd like to have the users be able to run the app without having to think about clicking a button to launch What command do I use or property do I modify? Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading, but not activating userform
hi
i would make the form modeless. userform1.show 0 the 0(zero) would make it modaless. that way the form would be showing but you can click on the sheet and work at the same time. then click back on the form when needed then switch back to the sheet when needed. read up on showmodal property in vb help. my thoughts regards FSt1 "c1802362" wrote: I've created a userform that I activate from 'ThisWorkbook' (userform1.show) when I open the file. As I understand the 'show' command, I have to interact with the form before I can work in the spreadsheet. In practice, I can't activate any of the cells, commands, etc until I close the form or select and launch the options on the form. What I'd like to be able to do is launch the file, work in the sheet as if it was a normal excel file, then run the form when required. I can achieve this haphazardly by creating a command button that launches the userform, but I'd like to have the users be able to run the app without having to think about clicking a button to launch What command do I use or property do I modify? Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing Workbook then Activating Other Wb with Userform showing? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Activating scroll bars in a text box on a userform | Excel Programming | |||
Activating a Userform in VB when changing Cells in Excel | Excel Programming | |||
Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming |