Rowsource not working properly :(

S

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
 
J

Juan Pablo González

You have to use the Initialize event for this:

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

Stift

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

So please reply and help me :
 
Top