Combo Box problem

[koda86]

Hi,

I am trying to create a Userform with Combo Boxes in, which take their Row Sources from cells. My problem is that what I need to put in the Combo Box is quite long text so I have to make a huge and long Combo Box to see my whole Text. Is there a way to put scroll bars in my Combo Box or to solve this problem?

Thank you

[Simon Lloyd]

Hi, Comboboxes do not use Row Source they use ListFillRange and cannot have a scrol bar assigned to them, you really need to use a textbox if you want scroll bars!

[koda86]

thanks for the quick reply!!! I will try with a text box instead!