ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform question (https://www.excelbanter.com/excel-programming/436267-userform-question.html)

Dawna

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

OssieMac

Userform question
 
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



All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com