VBA Excel VBEditor Checkboxes

[dprayner]

Hi good people.

I am working on a series of questions with checkboxes. When someone clicks the Yes checkbox, question A appears. When they click on the No checkbox, question B appears. When the form loads question A and B are not visible.

What I want to do is to make the questions invisible when the person unchecks the Yes or No checkbox. Any suggestions? DAVE

 

[SkipVought]

Hi,

Since you did not post your code, I'll give you an answer in prose.

In the checkbox click event, check the VALUE of the checkbox and assign the VISIBLE property of the textboxes explicitly, accordingly.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[fumei]

'Dat the way...

Gerry

 

[dprayner]

Thanks guys. Sometimes I seem to get hung up on the simplest control or code. I was trying to find an unclick event and didn't realize all I had to do is test for a False value.