Im trying to create comboboxes with buttons in an Excel spreadsheet
using the ActiveX toolbox.

I have been fairly successful coping the VB6 code from the excel help
menu.  The buttons & boxes will work even after the sheet is saved as a
template, but when I close the file and reopen it I seem to loose
the "link" between the VB6 code and the buttons & comboboxes in excel.

I have a feeling that I am either 1) not setting a property properly,
2) not including a required linking code, or 3)(most likely)Im making
this a whole lot harder than it has to be.

ALL I WANT IS TO HAVE DROP-DOWN BOXES THAT I CAN ENTER ALTERNATE DATA
INTO AND NOT HAVE THE "TOGGLE SWITCHES" SHOW when I print.

Following is the code I have entered in VB6 for my boxes & buttons...

Private Sub CommandButton1_Click()
ComboBox1.DropDown
End Sub

Private Sub ComboBox1_Change()

End Sub

Private Sub UserForm1_Initialize()
ComboBox2.AddItem "Stainless Steel"
ComboBox2.AddItem "Brass"
ComboBox2.AddItem "Ceramic"
ComboBox2.AddItem "Iron"
ComboBox2.AddItem "Carbon Steel"
End Sub

Thank you in advance,

Charles
--
c richard