"Edit Text" Event?

J

J. Mitchell

When text is being edited (e.g. in Excel, Project, etc.) many methods will
not work (error if called); the toolbars are also greyed.
What signals this state? I want my code to be able to avoid generating
errors, as it will definitely fail in such a state. TIA.
 
J

J. Mitchell

You can easily click a button on a toolbar, and since the button will then
run my code... which will not work during text edit...
 
L

Lars Hammarberg

Check the state of one of the built-in toolbar buttons - say Save (ID=3)
E.g.
If commandbars("standard").findcontrol(id:=3).enabled then
... run my code
else
... editing mode...
end if
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top