Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA/Macro - Textbox
I have created a small meal planner, in Excel2000.
I want to add a help box, similar to a comment box, using a macro and text box. Also when pressing the macro button can, the buttons text change. i.e Open Help/Close help. Any advice welcome Many Thanks Nic -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA/Macro - Textbox
Steelmaker;
You can have buttons that change their text ( caption ). Here is an example. Private Sub cbToggleDetails_Click() With frmDetails If .cbToggleDetails.Caption = "More Details" Then .cbToggleDetails.Caption = "Less Details" .cbMonth.SetFocus .Height = 275 Else .cbToggleDetails.Caption = "Less Details" .cbToggleDetails.Caption = "More Details" .cbMonth.SetFocus .Height = 125 End If End With End Sub Succes; Mark. More Excel ? www.rosenkrantz.nl or ------------------------------------------------------------------ "thesteelmaker " wrote in message ... I have created a small meal planner, in Excel2000. I want to add a help box, similar to a comment box, using a macro and a text box. Also when pressing the macro button can, the buttons text change. i.e. Open Help/Close help. Any advice welcome Many Thanks Nick --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
'Find' textbox value macro | Excel Discussion (Misc queries) | |||
a macro that Formats a textbox based on value in a cell | Excel Worksheet Functions | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |