Assigning text in a cell to a macro

[Saturn]

I have cell with some ordinary text.
Is it possible to I assign that text (or the cell itself) to a macro? An hyperlink is not an option.
Saturn

[TMS]

What do you mean by assign the text in a cell to a macro?

[Saturn]

By clicking the text I want to run the macro.
There is noe problem with assigning a shape or an image to a macro, but text in a cell.....

[TMS]

If you want to activate a macro by clicking on in a cell, you could use a Worksheet Selection Change event handler.

For example:

Please Login or Register  to view this content.

Right click on the worksheet tab; select View code and copy and paste the code above into the empty page.

When you click on a cell, it will display the address and the value.

Regards, TMS

[Saturn]

Thanks for your answer TMS but I am in doubt how this procedure can help me with activating the macro in question .....

[TMS]

What "macro in question"?

Just replace the message box with a call to your macro. I don't know what the macro does or what input it needs as you have not shared that information.

Regards, TMS

[Saturn]

I am still stuck. Enclosed is a workbook where I have two macros and they perform a very simple example task.
I have placed your example above in both a separate module as well as in sheet1 in the VBEditor.
I admit I am lack of basic VBA knowledge but could you modify the workbook so it will perform the task when pressing the cell, for an A and a B respectively ?