If Macro Button Clicked

[StevieT2301]

Hi there,

I am looking to create cell content in let's say cell A1 if a macro button in the same sheet has been clicked.

Is anyone able to help please?

Thanks very much.

[Richard Buttrey]

Hi,

Perhaps the simplest way is to insert a Shape button
Create a macro like the following

Please Login or Register  to view this content.

Then right click the shape Choose Assign macro and select the procedure above.
, right click the shape click

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

If A1 is double clicked then input is cell content?

[Richard Buttrey]

Thanks for the rep.

[JOHN H. DAVIS]

Thanks for the rep.