Resetting a form control combo box without using VBA

[Chris Shepherd]

Hi,

I was wondering if it is possible to reset a form control combo box without having to use VBA. I know VBA would be easier, but I am trying to build this spreadsheet without using VBA if possible.

Thanks in advance,

Chris

[Tony Valko]

This may not be as helpful as you'd like but...

If you use the linked cell and clear the contents of the linked cell that will also clear the selection from the combo box.

I don't know how you'd clear the linked cell without using VBA or doing it manually.

[Chris Shepherd]

Thanks for the reply... I think I will just have to bite the bullet and go VBA, as I have other things I want to do with check boxes that I can't seem to get done with formula alone.

[Tony Valko]

Good deal. Thanks for the feedback!