Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed! How use a Command Button to pop up a text box in Excel?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed! How use a Command Button to pop up a text box in Exc
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). -- Regards, Tom Ogilvy " 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed! How use a Command Button to pop up a text box in Excel?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command button text | Excel Discussion (Misc queries) | |||
Command Button Error - Help Needed Urgently Please | Excel Worksheet Functions | |||
Is there a Wrap Text command button? | Excel Discussion (Misc queries) | |||
Help needed moving a command button | Excel Programming | |||
Command Button text changes size | Excel Programming |