Thread
:
Help needed! How use a Command Button to pop up a text box in Excel?
View Single Post
#
1
Posted to microsoft.public.excel.programming
davegb
external usenet poster
Posts: 573
Help needed! How use a Command Button to pop up a text box in Excel?
Sub Button1 ()
Msgbox "Put your info here"
end sub
Assign the macro to the button.
wrote:
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?
Reply With Quote
davegb
View Public Profile
Find all posts by davegb