Excel VBA/Macro - Textbox

  • Thread starter Thread starter thesteelmaker
  • Start date Start date
T

thesteelmaker

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
 
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 (e-mail address removed)
 
Back
Top