Help needed! How use a Command Button to pop up a text box in Excel?

[matt]

Greetings all:

Quick (and likely very easy) question for the collective Excel wizards
of this forum. I'm a novice user of Excel, simply looking to add a
command button to my worksheet that would pop up some kind of floating
textbox when clicked, giving the users some additional notes and
comments about the sheet in question. It wouldn't need to make any
calculations or gather user input of any kind -- just display some
helpful hints -- and I feel the "Comments" feature in Excel is a bit
too limiting for this purpose and hard for the average user to see.

Can anybody quickly point me in the right direction on how to
accomplish this? I've browsed around the web for an hour, looking for
a solution, and I just don't think I'm using the right vocabulary. I
know how to create a Command Button, but don't how to make this button
actually do what I want and whether I need to write a macro of some
kind or whether there's a built-in function or wizard that will serve
the purpose. Obviously, if there's any way to pull it off WITHOUT
writing VB code, that would be preferable, since I'm not skilled in
that regard.

I've got to think this functionality is fairly simple, however,
compared to all of the other amazing stuff I've seen that Excel can
accomplish. Thoughts? Suggestions?

 

[Guest]

Have you look at Data=>validation

It might provide what you want. the wizard has three tabs. The second two
provide the ability to provide the kind of help I believe you want. the
second tab provides Input help and the third tab provides help if the entry
is flawed.

It also can be used to limit what is entered (primary purpose).

the input help is shown when the cell is selected.

if you are still looking at the commandbutton, when you first place it on
the sheet, double click on it and you will go to

Private Sub Commandbutton1_click()

End Sub

In there you can put code like
Private Sub Commandbutton1_click()
dim msg as String
msg = "Sentence line 1" & vbNewline & "Sentence Line 2"
msgbox Msg
End Sub

then go back to excel and get out of design mode (first button on control
toolbox toolbar).

 

[davegb]

Sub Button1 ()
Msgbox "Put your info here"
end sub

Assign the macro to the button.