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?
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?
Great video and suggestion Raustin