is it possible to link a cell from macro button

[deanusa]

Hi all,

Is it possible to have various buttons in one sheet in excel, and as they're pressed cell A1 in another sheet updates with the names range of each button pressed? If button A was pressed cell A1 would say Button A. If someone pushed Button B, cell A1 would show Button B

Similar to Linkedcell in properties when inserting something like an activex userform

Many thanks!!!

[moinsk21]

Hi Deanusa,

Yes, it can be possible, please share your spread sheet so we will have a better idea to complete this task.

Thanks!
Moin

[Richard Buttrey]

Hi,

Assuming you mean an Activex Command button then set the Caption property of the button to 'Button A'. Then in the click event of the button enter

Please Login or Register  to view this content.

If you mean another sort of button like a drawing object shape, then do something similar but create a module level macro and with the Assign_Macro option point it to the macro procedure.

[Jakobshavn]

See the attached:


For Forms buttons

[deanusa]

Thanks this works perfectly !!! It was for a shape rather than a command button, but as you say just attach it and done! thanks so much!