| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keep on working while userform is active
I was wondering if it possible to keep on working/editing an Excel
worksheet while a userform is loaded. So, you need to be able to see the info on my userform and at the same time be able to work the worksheet. Thanks in advance for any responses. Robert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
keep on working while userform is active
Hello Robert
Yes this is possible, use the Modal value VbModeless eg: UserForm1.Show vbModeless HTH Cordially Pascal "Robert" a écrit dans le message de news: ... I was wondering if it possible to keep on working/editing an Excel worksheet while a userform is loaded. So, you need to be able to see the info on my userform and at the same time be able to work the worksheet. Thanks in advance for any responses. Robert |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
keep on working while userform is active
Thank you very much. works perfect.
On 2 okt, 13:23, "papou" wrote: Hello Robert Yes this is possible, use the Modal value VbModeless eg: UserForm1.Show vbModeless HTH Cordially Pascal "Robert" a écrit dans le message de news: m... I was wondering if it possible to keep on working/editing an Excel worksheet while a userform is loaded. So, you need to be able to see the info on my userform and at the same time be able to work the worksheet. Thanks in advance for any responses. Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm - Last Active control | Excel Programming | |||
| UserForm Active | Excel Programming | |||
| userform - active sheet | Excel Programming | |||
| Viewing a worksheet while a UserForm is active | Excel Programming | |||
| Accessing a non-active sheet from a userform | Excel Programming | |||
![Robert[_33_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
