Form Combobox horizontal list help

[Ben_goldfinch]

I have a combobox where i am trying to get the list o refer to a horizontal list with he first cell named BBFCRatingStart and then to finish at the end of the list depending on how many cells are filled in this is what i have but clearly i am doing something wrong.
wsLists is is the name of the worksheet they are on and FilmCertificate is the name of the combobox on the form

FilmCertificate.List = Application.WorksheetFunction.Transpose(wsLists.Range("BBFCRatingStart:BBFCRatingStart.End(xlToRight))"))

 

[steve the fish]

How about something like:

FilmCertificate.List = Application.Transpose(Range(Range("BBFCRatingStart"), Range("BBFCRatingStart").End(xlToRight)))

 

[Ben_goldfinch]

That did the trick, thanks you are a gentleman and a scholar