Thread: combo boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SARAH SARAH is offline
external usenet poster
 
Posts: 8
Default combo boxes

Hi,

I created a few comboboxes in my ms excel 2000 spreadsheet
and filled them using the VBA commands like:

ComboBox3.List = Array("No", "Yes")

When I later re-open the spreadsheet, the comboboxes are
empty! I have to recompile the code to see the items in
the comboboxes.

Does anyone know why this is happening and how to fix it!?

Thanks :)