Is it possible to populate a combo box with a range or values that exists 1 row and not a column?

[dbkimber]

I have a dynamic range that all the info in is 1 row and I want to use it to populate a combo box but I can only get the value in the first cell to show in the combo box.
Range named adbk is on a tab named Admin and the data starts in b1 and stretches out on row 1 below is the line of code that I have that will give me the first value

cmbtsk.List=sheets(“Admin”).Range(“adbk”).value

Any advice you might have would be a big help

 

[Fluff]

How about

cmbtsk.List=Application.Transpose(sheets(“Admin”).Range("adbk").value)

 

[dbkimber]

i tried this yesterday and for an error. trying it now i have a different error that is "script out of range"

 

[dbkimber]

never mind i fixed my issue. thanks for the help its is now working

 

[Fluff]

You're welcome & thanks for the feedback