Hey, ok I added the code to the work-book, and Im getting an error saying, "Could not set the box property, unspecified error", and for some reason the combo box is has 'Transmittal 1' listed, but still not being populated with <Transmittal 2> and <Transmittal 3>
I think Transmittal 1 is there, because I placed it there by editing the text field in the properties window...but the issue still exists, when I try and add
[vba] Sheets("Data").ComboBox1.Clear
Sheets("Data").ComboBox1.AddItem "Transmittal 1"
Sheets("Data").ComboBox1.AddItem "Transmittal 2"
Sheets("Data").ComboBox1.AddItem "Transmittal 3"
Sheets("Data").ComboBox1.Text = Sheets("Data").ComboBox1.List(0)[/vba]

to the work-book...I get the error I spoke of above.

I included an attachment