Exit Macro to disable a field 1

[snapshot]

Total novice in VBA - I want an exit macro in a drop down form field that will disable certain check boxes. Could anyone give me a code example to start from please?

 

[SkipVought]

Hi,

What kind of checkbox -- Form or Control Toolbox?

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[snapshot]

sorry - just a form check box.

 

[TaintedFlames]

Hi,
well whatever event you want to step this up to.

This is the code that would close your macro.
'GUI is your main
Unload GUI
Set GUI = Nothing
Hope this helps

Jay

 

[SkipVought]

Also what application?

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[snapshot]

Word.

 

[SkipVought]

formfields("MyCheckBox").Enabled=false

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[snapshot]

Many thanks SkipVought. Exactly what I wanted.