Combobox indirect lookup

[jonhigson]

HI, I am being skirting around VBA for years and this is my first real attempt using it and Userforms.

I need a Combobox that will lookup a list based on information calculated within the spread-sheet. If I was to use excel and Data validation I would put the formula =indirect(Cell Ref). Below is the code and what I have attempted, I am stuck on "Printspeccombobox" part.

Hopefully you can see what I am trying to accomplish. Thanks

Private Sub UserForm_Initialize()

'Empty Stockcodetextbox
stockcodetextbox = ""

'Empty Finishingcombobox
finishingcombobox.Clear

'empty printspeccombox
printspeccombobox.Clear

'Empty Qty_1textbox
QTY_1textbox = ""


'Fill Finishingcombobox
With finishingcombobox
.AddItem "none"
.AddItem "Phos"
.AddItem "Folding"
End With

'Printspeccombobox

printspeccombobox.RowSource = Range('Formula & Lookup'!C6).address


End Sub

[DBY]

Hello
Assuming there is a named range equivalent to the value of cell C6, the following should work:

Please Login or Register  to view this content.

Hope this helps.
DBY

[jonhigson]

Thanks DBY that's sorted it.

Regards Jon