| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform question
how do I make it possible to click on a cell in a worksheet when the userform
is still open? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm Question | Excel Programming | |||
| UserForm Question | Excel Programming | |||
| UserForm Question | Excel Programming | |||
| UserForm Question | Excel Programming | |||
| userform question | Excel Programming | |||
Hybrid Mode
