Dave: Thanks for your responses. The first response would work, in a round
about way. The MsgBox was an option, however I have not made professional
looking MsgBoxes (long ones) and it is a large amount of words. In my
initial research I started with Walkenbach's Chapter 23 "Providing Help for
Your Applications" from his book Excel 2000 Power Programming w/ VBA. I
thought there would be easier ways such as attaching a comment to a
object/shape.

I will go from here, to the site you led me to.

Again thanks you and the others for your time and help.

"Dave Peterson" wrote:

You could assign a macro to that rectangle (just rightclick on it and choose
assign macro).

If the amount of words is small, you could use a message box:

option explicit
sub testme()
msgbox "Your help text here"
end sub

If the amount of words is large, you could create your own user form and show
that.

John Walkenbach has done lots of the work for you:
http://j-walk.com/ss/excel/tips/tip51.htm

Ronbo wrote:

Sorry for the bad question.

Thanks for the help.

I want to find a way that I can create a help button (a text box named
"rectangle 13") so that if the user needs help on the tem, they can click on
the help object and a help screen like a comment will popup.

I have an Object = Rectangle 13. To it i added a macro "a"

macro "a" = ActiveSheet.Shapes("Rectangle 13").Comment.Text Text:="Test"
& Chr(10) & ""

I hope this helps some.

Again, Thanks for the help

"Dave Peterson" wrote:

If you mean a shape on the worksheet, maybe you can widen the column, increase
the row height and put a comment on that cell that is below that object.

You'll see the comment when your mouse is over the cell, but not over the shape.

Ronbo wrote:

How can I add a comment to an object?

As always thanks for any help.

--

Dave Peterson


--

Dave Peterson