Userform question

D

Dawna

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
 
O

OssieMac

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

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
merging workbooks with userforms 1
Click on userform transfers to lisbox below 1
closing another file by code causes failure to run workbook activate event 2
Avoid compile error if userform doesn't exists??? 1
Worksheet appears briefly before UserForm opens 4
Userform dropdown doesn't go away 0
Userform to Select what worksheets to print 1

Top