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

--
Regards,

OssieMac


"Dawna" wrote:

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