Rowsource not working properly :(

[Stift]

I've got a Combobox on a userform and I've set the rowsource(in th
properties tab) to : =Q7:BQ7

But now it only shows the content of cell Q7 and not the other cells.
What do I have to change to fix it ????


Thanks in advance for helping me!


Greetz Stif

 

[Juan Pablo González]

You have to use the Initialize event for this:

ComboBox1.List = Application.Transpose(Range("Q7:B7"))

 

[Stift]

So nobody is able to help ????
I can't solve this myself ,but I bet a lot of members here can help
me!!

So please reply and help me :

 

[Dave Peterson]

You got one reply already.

http://groups.google.com/[email protected]

Did it not work for you?