Hello,

I am hoping to find an explanation on how Excel/VBA works with ComboBoxes. So far I couldn't find a step by step introduction for beginners. From doing research on the Internet, I learned that we can manipulate ComboBoxes by Creating Private Sub routines inside different objects (Sheet1, Thisworkbook, etc.)

I would like to know, (1) In which objects should I write code for things like populating the ComboBoxes List, assigning a linked cell, etc., and (2) how do I need to name this routines (I saw that VBA automatically creates routines like Workbook_Open, ComboBox1_Change, etc.)

My ultimate goal is simply to create a ComboBox with a predetermined list of possible values, and a linked cell. I am using Office 2003.

Thanks a lot!