default drop down box

**damo07** · 06-25-2010, 08:06 PM

Hi everybody,

I have a questionnaire that has yes/no drop down boxes.

The second question is activated by the response to the first question, so in affect I don't want the respondents to see the second question before the first is answered.

Therefore I was wondering how I would default the excel file to only show only the first question, with the drop down box being blank.

Any help would be appreciated.

Thanks
Damian

**Palmetto** · 06-25-2010, 08:25 PM

You need to be more explicit about the kind of drop down box. Are you using dependent list via Data Validation or a combo box from the Forms or Active-X controls?

how I would default the excel file to only show only the first question, with the drop down box being blank

You would need to use VBA in the workbook_open event to clear the contents of all cells except the first question drop down.

Basic idea:

Please Login or Register  to view this content.

**damo07** · 06-25-2010, 08:32 PM

Thanks,

I am using a drop down box via data validation. Will this VBA you have supplied work?

Cheers.

**Palmetto** · 06-25-2010, 08:40 PM

Yes. Just adjust the sheet and range reference.

Note: The sheet name in the above code is not the worksheet name (as shown the sheet tab), but the VBA code name for the sheet (name shown in brackets in the VB Project Explorer window).

This code MUST go into the workbook module. Press Ctrl + F11 keys to open the VB editor, double-click the "Thisworkbook" module and paste in the above code.