Thread: User Form focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_2_] Glen Mettler[_2_] is offline
external usenet poster
 
Posts: 27
Default 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