Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form focus
I have a user form that contains options that will be place in the selected
cell. It works fine in modal status. However, I wanted to make the form non-modal so the user could select more than one cell to insert the data so they would not have to repeat the action several times. Here is the problem. When I set the form non-modal, the focus remains in the cell awaiting input. I cannot select the form. However, I can move the cursor to another cell and then back and then select the form. I tried to set the focus to the form or an object in the form (like the OK button). Have I missed something? I want to run the form non-modal and have the focus on the form when it is envoked. Is that possible? Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modeless User Form and Worksheet Focus | Excel Programming | |||
Sending Form Focus? | Excel Programming | |||
Text Box on User Form Set Focus Issue | Excel Programming | |||
How to set focus back to sheet after showing a user form | Excel Programming | |||
How to set focus back to sheet after showing a user form | Excel Programming |