View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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