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

--
Message posted from http://www.ExcelForum.com

You have to use the Initialize event for this:

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

--
Regards

Juan Pablo González

"Stift " wrote in message
...
I've got a Combobox on a userform and I've set the rowsource(in the
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 Stift


---
Message posted from http://www.ExcelForum.com/

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 :

--
Message posted from http://www.ExcelForum.com

You got one reply already.

http://groups.google.com/groups?thre...rum-nospam.com

Did it not work for you?

"Stift <" wrote:

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 :(

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson