Help writing macro

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?
 
D

Daryl S

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
 
N

newby

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top