Userform question

  • Thread starter Thread starter Dawna
  • Start date Start date
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
 
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
 
Back
Top