Hey Mangesh,

So the VBA code I changed it to:

Sub Auto_Open()
'... more stuff here

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

'... more stuff here
End Sub

But when I reopen the spreadsheet, the comboboxes are
still empty?!

I entered in the data on another sheet and I used the
range (sheet2!a1:a2)... to hold the data. but that
combobox is not in the location I want on the spreadsheet,
its just a separate userform. :S

Help please! :D


-----Original Message-----
ok. In that case, do the following. As you said earlier,
you have the
vba command ComboBox3.List = Array("No", "Yes"). Name the
sub in which
this line is as:

Sub Auto_Open()

This would be enough.

- Mangesh


---
Message posted from http://www.ExcelForum.com/

.