Combo Box/Drop Down menu in MS Excel

[AnT2nY]

Hi,

I am doing AVCE ICT and i need to find out how to make a drop down menu.

I have already found 2 ways (described below) but i was wondering whether anyone knows how i could use a VBA script to add the data into the drop down menu.

Validation Method:

enter Jan - Dec in Cells A1-A12 goto Data > Validation > Settings Tab > select Allow List > Click on Source Range And highlight Cells A1-A12

Other Method:

View > Toolbars > Forms > Select Combo box and draw it somewhere > right click the drop down menu/combo box > Format Control > Select Input Range (highlight A1-A12 (Jan-Dec)) > click on cell and clikc anywhere on the spreadsheet> and then click ok.

However i dont like either of these methods as the data has to be entered onto the sheet.

I have sort of found out about the VBA way but getting stuck.

Heres how i have kinda done it.

View > Toolbars > Control Toolbox > select combo box and draw it > right click the drop down menu and click view source.

please can anyone help i have office XP & 2003