Userform question



What do I need to do if I want to access a cell in my worksheet if I have a
userform open? (I have to close the userform in order to access the cell)

Thank you in advance


In the forms properties set the Property ShowModal to False.

Alternatively in the code to show the userform
UserForm1.Show vbModeless

The opposite of the above line is
UserForm1.Show vbModal

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question