Hi Gang,

I am building a Macro to open UserForm1 so that the user can access either UserForm1 OR the worksheet behind UserForm1.

Since it's Macro, the code is in a Module...

Please Login or Register  to view this content.
With this Macro I can access all controls BEHIND UserForm1 (This is good). However, I am unable to access any controls on UserForm1. Instead I get that deep, hollow, unresponsive 'Boink' sound while clicking on UserForm1 (This is bad).

When I change the code to: UserForm1.Show - I can access all controls on UserForm1 (this is good) but I'm unable to access anything else (this is bad).

I've also tried to change the UserForm1 Property 'showModal' - but showModal demands to be set to true in order to access any of the form controls??

When UserForm1 'showModal' is set to false I get that unresponsive 'Boink' sound while clicking on UserForm1.

Thanks for any suggestions.

JJ