how do I make it possible to click on a cell in a worksheet when the userform is still open?
D Dawna Nov 17, 2009 #1 how do I make it possible to click on a cell in a worksheet when the userform is still open?
O om Nov 17, 2009 #2 Hi Dawna You will have to make the form Modeless by adding following line to form's load event UserForm1.Show vbModeless Regards Om
Hi Dawna You will have to make the form Modeless by adding following line to form's load event UserForm1.Show vbModeless Regards Om
R Rick Rothstein Nov 17, 2009 #3 Show your UserForm (assumed to be named UserForm1 for this example) like this... UserForm1.Show vbModeless
Show your UserForm (assumed to be named UserForm1 for this example) like this... UserForm1.Show vbModeless
D Dawna Nov 18, 2009 #4 Thank you both! Dawna Rick Rothstein said: Show your UserForm (assumed to be named UserForm1 for this example) like this... UserForm1.Show vbModeless -- Rick (MVP - Excel) . Click to expand...
Thank you both! Dawna Rick Rothstein said: Show your UserForm (assumed to be named UserForm1 for this example) like this... UserForm1.Show vbModeless -- Rick (MVP - Excel) . Click to expand...
