ExcelBanter - userform question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - userform question (https://www.excelbanter.com/excel-programming/436263-userform-question.html)

Dawna

userform question

how do I make it possible to click on a cell in a worksheet when the userform
is still open?

userform question

Hi Dawna

You will have to make the form Modeless by adding following line to form's
load event

UserForm1.Show vbModeless

Regards
Om

"Dawna" wrote:

how do I make it possible to click on a cell in a worksheet when the userform
is still open?

Rick Rothstein

userform question

Show your UserForm (assumed to be named UserForm1 for this example) like
this...

UserForm1.Show vbModeless

--
Rick (MVP - Excel)

"Dawna" wrote in message
...
how do I make it possible to click on a cell in a worksheet when the
userform
is still open?

Dawna

userform question

Thank you both!

Dawna

"Rick Rothstein" wrote:

Show your UserForm (assumed to be named UserForm1 for this example) like
this...

UserForm1.Show vbModeless

--
Rick (MVP - Excel)

"Dawna" wrote in message
...
how do I make it possible to click on a cell in a worksheet when the
userform
is still open?

.

All times are GMT +1. The time now is 02:31 PM.