comment for a shape?

[merlin777]

I have a shape which is a button that runs a macro but i want to add a comment to explain what it does before the button is clicked on.

Is it possible to have a text message pop up when you mouseover a shape?

 

[Raustin]

what do you mean by'assign a specific (hidden) cell to that shape'?

When you add any shape to a worksheet, select that shape. The go to the formula bar and type in "=", then select any cell within the sheet and hit "Enter". From that point, any text you type into the specified cell will then be displayed as text on the shape. I hope this helps

 

[Raustin]

what do you mean by'assign a specific (hidden) cell to that shape'?

You may also want to hide the row/ column which is assigned to this shape as it is probably not needed for the average user or viewer

 

[merlin777]

wow - i never knew you could do that!

I tried in the past but just ended up with text typed into the box. I have trouble selecting between modes in shapes...

 

[My Aswer Is This]

I believe he means. Click on your shape then click in the formula bar and put in "=A1" and then what ever text in placed in A1 will now show up in your shape.

 

[Raustin]

I believe he means. Click on your shape then click in the formula bar and put in "=A1" and then what ever text in placed in A1 will now show up in your shape.

Yes that is what i mean. Sorry i am terrible about explaining things, but im working on it.
I did find another cool 'sort of' solution that will achieve your original goals. I want to make a pop-up menu on mouse hover over shape so i need this functionality as well. Take a look at this youtube video

 

[merlin777]

Brilliant, thanks. I didn't realise that if you clicked in the formula bar the shape went into 'link mode' but if you just typed with the shape selected you get text edit mode.

The only thing I still don't understand is where the macro is run from. You can't assign a macro to a cell so it must be on the shape you've made but if that's the case, why not just put 'show help' directly into the shape rather than linking to a cell?

 

[My Aswer Is This]

Merlin:
You can assign a Macro to a cell.
Right click on your sheet tab choose view code and put in this code:
Then when you click on cell A1 your code will run

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
Do this
End sub

 

[merlin777]

magic - thanks!

 

[My Aswer Is This]

Merlin:
Just so you will know you can do this multiple times in one sheet like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = Range("A1").Address Then
Do this
End if
If  Target.Address = Range("A2").Address Then
Do this
end if
If  Target.Address = Range("A3").Address Then
Do this
end if

End sub

 

[merlin777]

even more magical...