Help writing macro

  • Thread starter Thread starter newby
  • Start date Start date
N

newby

Please I will appreciate if someone could help me write the code/macro (not
sure which one I am supposed to do) for an event to make a textbox visible
when the preceeding checkbox for "other" is checked. Then where would I put
the code, new macro or event?
 
newby -

This is code - open the Properties of the checkbox, go to the Events tab,
and select the OnClick event. Use the drop list in the blank field to the
right to select [Event Procedure], and click the elipses at the end of the
line (...) That will bring up the code window for the OnClick Event of the
checkbox. Put in the following code, substituting your names for the
txtBoxName and CheckBlxName:

Me.txtBoxName.visible = Me.CheckboxName.Value
 
Thanks a lot Daryl!

Daryl S said:
newby -

This is code - open the Properties of the checkbox, go to the Events tab,
and select the OnClick event. Use the drop list in the blank field to the
right to select [Event Procedure], and click the elipses at the end of the
line (...) That will bring up the code window for the OnClick Event of the
checkbox. Put in the following code, substituting your names for the
txtBoxName and CheckBlxName:

Me.txtBoxName.visible = Me.CheckboxName.Value

--
Daryl S


newby said:
Please I will appreciate if someone could help me write the code/macro (not
sure which one I am supposed to do) for an event to make a textbox visible
when the preceeding checkbox for "other" is checked. Then where would I put
the code, new macro or event?
Click to expand...
Click to expand...
 
Back
Top