focus issue?

ottomatic · #1 (**permalink**) 02-16-07, 12:09

I have a main form (within excel), when the user double clicks a particular control a sub-form will open for them to enter data. When the user clicks OK on the subform, it hides but the next mouse click on the form has no effect, the user has to click a second time, make sense?

I'm using form.show and form.hide to open and close the subform.

davesexcel · #2 (**permalink**) 02-24-07, 14:33

Quote:

Originally Posted by ottomatic

I have a main form (within excel), when the user double clicks a particular control a sub-form will open for them to enter data. When the user clicks OK on the subform, it hides but the next mouse click on the form has no effect, the user has to click a second time, make sense?

I'm using form.show and form.hide to open and close the subform.

what is the function of the second userform??

Internet Services

Web Development

Digital Marketing

Consumer Tech