listindex

[Steph]

Hi. Another combobox question - After the user enters data, the combobox
hides. When re-initialized, the data enter the previous time is still
there. How do I clear the form so nothing defaults in? I have both text
boxes and comboboxes.

I read on google that to clear a combobox, set listindex in the properties
menu to -1. I have excel 2003, and I don't see a listindex property
listed!?

Thanks for your help!!

 

[Bob Phillips]

That is probably because you are using a combobox from the Forms toolbar,
not the Control Toolbox ox toolbar

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)