| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"box-select" mode
Hi,
I now understand that: Application.CommandBars("Drawing").Controls("Selec t Objects").Execute puts me into the box-select mode. And running Application.CommandBars("Drawing").Controls("Selec t Objects").Execute again puts me out of box-select mode. Is there a way to tell if the control("select objects") is currently selected because sometimes I want to only excute that code if it is not currently in the box-select mode. Thanks for you help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"box-select" mode
Maybe you can use something like:
Dim myCtrl As CommandBarControl Set myCtrl = Application.CommandBars("Drawing").Controls("Selec t Objects") If myCtrl.State = msoButtonUp Then MsgBox "ready to turn on" myCtrl.Execute Else MsgBox "already clicked" myCtrl.Execute End If borg wrote: Hi, I now understand that: Application.CommandBars("Drawing").Controls("Selec t Objects").Execute puts me into the box-select mode. And running Application.CommandBars("Drawing").Controls("Selec t Objects").Execute again puts me out of box-select mode. Is there a way to tell if the control("select objects") is currently selected because sometimes I want to only excute that code if it is not currently in the box-select mode. Thanks for you help! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"box-select" mode
Thank you for the help! It is much appreciated.
"borg" wrote: Hi, I now understand that: Application.CommandBars("Drawing").Controls("Selec t Objects").Execute puts me into the box-select mode. And running Application.CommandBars("Drawing").Controls("Selec t Objects").Execute again puts me out of box-select mode. Is there a way to tell if the control("select objects") is currently selected because sometimes I want to only excute that code if it is not currently in the box-select mode. Thanks for you help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Hybrid Mode
