Problem with Event Coding for user Forms in VBA

Posted by Jim Dillon on August 03, 2001 4:35 AM

Hi Guys,

Compliments to all you Gurus - This Board is positively the best I have seen

I need help. please.

I am develping a small applicaion in VBA (Excel) and
am using nested UserForms to interact with the file.

The problem manifests itself when I use a command button on frm1 to fire the load event of frm2.

frm2 loads but none of its optButtons are available.

However, they do come available when you click one and then quickly click another. But only the second optButton carries out its code.

I think it is something to do with SetFocus or GotFocus
but these do not seem to be available in VBA.

Any solutions?

Thanks,

Jim

Posted by Jerid on August 03, 2001 6:26 AM

Can you provide a sample of your code?

Jerid

Posted by Jim Dillon on August 03, 2001 7:56 AM

Thanks Jerid,

It's a wee bit complex wrte the code

but if you give me you email address (which will obviously remain private between us) I can send you the file and you can take a look.

I have a work around in use at the moment but the copy I send you will have the orginal probelmatic code.

Thanks

Jim