| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click on worksheet with UserForm open?
My macro works and the Form looks okay for a beginner. But if the user
doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click on worksheet with UserForm open?
Ed,
You could set the form's ShowModal property to false and the user can still move the cursor with your form showing... -- Charles www.officezealot.com "Ed" wrote in message ... My macro works and the Form looks okay for a beginner. But if the user doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click on worksheet with UserForm open?
Thank you, Charles! That did the trick.
Ed "Charles Maxson" wrote in message ... Ed, You could set the form's ShowModal property to false and the user can still move the cursor with your form showing... -- Charles www.officezealot.com "Ed" wrote in message ... My macro works and the Form looks okay for a beginner. But if the user doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click on worksheet with UserForm open?
This is not working in excel 97 Ed.
If you have users that use this version then you can't open the userform like this. -- Regards Ron de Bruin http://www.rondebruin.nl "Ed" wrote in message ... Thank you, Charles! That did the trick. Ed "Charles Maxson" wrote in message ... Ed, You could set the form's ShowModal property to false and the user can still move the cursor with your form showing... -- Charles www.officezealot.com "Ed" wrote in message ... My macro works and the Form looks okay for a beginner. But if the user doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click on worksheet with UserForm open?
i think you could use the RefEdit activeX control, and select the range in
th same way that you can with the function builder on a worksheet. "Ron de Bruin" wrote in message ... This is not working in excel 97 Ed. If you have users that use this version then you can't open the userform like this. -- Regards Ron de Bruin http://www.rondebruin.nl "Ed" wrote in message ... Thank you, Charles! That did the trick. Ed "Charles Maxson" wrote in message ... Ed, You could set the form's ShowModal property to false and the user can still move the cursor with your form showing... -- Charles www.officezealot.com "Ed" wrote in message ... My macro works and the Form looks okay for a beginner. But if the user doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click on worksheet with UserForm open?
Thanks for the reminder, Ron. I'm in XP and my friend is using either XP or
2000, so we're okay. Ed PS - I use your Google search add-in several times a week. It has saved my bacon many times. "Ron de Bruin" wrote in message ... This is not working in excel 97 Ed. If you have users that use this version then you can't open the userform like this. -- Regards Ron de Bruin http://www.rondebruin.nl "Ed" wrote in message ... Thank you, Charles! That did the trick. Ed "Charles Maxson" wrote in message ... Ed, You could set the form's ShowModal property to false and the user can still move the cursor with your form showing... -- Charles www.officezealot.com "Ed" wrote in message ... My macro works and the Form looks okay for a beginner. But if the user doesn't have the correct cell selected before launching the UserForm, can I allow him to click on the worksheet to select a different cell without having to close the form and relaunch? Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
| How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
| Click a command Button to open small worksheet. | Excel Discussion (Misc queries) | |||
| Excel files don't open until a click on blank worksheet | Excel Discussion (Misc queries) | |||
| select row in userform listbox with right-click? | Excel Programming | |||
![Ed[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
