Cannot Find Button From Control Properties
You are out of luck on that one. No code will run while a cell is in edit
mode. No events fire... Nothing...
That being said you can reference a button from the forms toolbar like this...
MsgBox Sheets("Sheet1").Buttons("Button 1").Caption
--
HTH...
Jim Thomlinson
"cdun2" wrote:
Hello,
On my worksheet, I have dropped a button control from the Forms
Toolbar. I have aasigned a macro to the button. The on click event
(??) of the button fires the macro properly, and I get the results I
expect. However, a cell has to be edited before the button can be
clicked. Before the button is clickable, I have to be out of edit
mode.
In VBA, I cannot find a way to reference this button control. The
button is not in a form, its embedded within the worksheet. I would
like to be able to exit edit mode when I mouseOver the button.
What should I do?
Thank you for your help!
cdun2
|