Excel Combo Box query

[peterattheboro]

Is it possible to create a macro which will create a combo box in cell A1, insert the entries for the menu and then go on to do the same with A2, A3, A4 right upto A450?

I can create this macro but I just can't get it to continue onto the next row into the position that I want it. Also the box needs to enter a number into a cell on the same row.

So A1 will enter a number into $P$1 depending on who is selected from the menu.
A2 will enter $P$2
A3 will enter $P$3

Thanks.

Apologies if it's a little confusing

 

[peterattheboro]

Thanks guys. I'll have a go with this in the morning as my head is farting right now and it's nearly home time!

 

[peterattheboro]

I've tried this code but it's an OLE object and I can't work with it. Can't do anything with the box once it's been placed.

This is the code I am trying to work with:

'

'
    ActiveSheet.DropDowns.Add(0, 114.75, 67.5, 15.75).Select
End Sub

That's just a standard combo box being placed on the sheet.