Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedding Command Buttons in a Text box or List box
Hello,
Is there away to embed a command button in a textbox or list box? The textbox or listbox acts as a message, and then the command button hides the message once you click it. Is there another way to do this? Thanks *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedding Command Buttons in a Text box or List box
Lester,
You could assign a macro to a text box - from the drawing toolbar - and assign this macro to it. Put the macro in a general module and assign it by right-clicking, as you would with a button from the Forms bar. The textbox basically acts like a big button when you click it and the macro makes it disappear. If you need it to be visible again, you'll need to code for that. Change the textbox name to suit: Sub disappearing_box ActiveSheet.Shapes("MyTextBox").Visible = false End Sub hth, Doug Glancy "Lester Lee" wrote in message ... Hello, Is there away to embed a command button in a textbox or list box? The textbox or listbox acts as a message, and then the command button hides the message once you click it. Is there another way to do this? Thanks *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Novice Question: Text Size on Command Buttons | Excel Programming | |||
Embedding command buttons in cells | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming |