Combo Box will not display Input Range for Same Row (i.e $6:$6)

[g00glethis1]

Combo Box will not display Input Range for same Row (i.e $6:$6) & will only display my data if it is in the same column.

What can I do so my combo box will display same row data ($6:$6) vs having to use a column?

[g00glethis1]

It is the combo box from the forms toolbar.

I don't know what you mean by populated. I'm sorry...

I just want the data From Row 6 to show up in my Combo Bow. That is all

<---n00bie

[davesexcel]

I don't believe this is going to happen with a combo box from the forms toolbar.

You may be able to use transpose in the combo box from the controls toolbar, but this would require VBA

[g00glethis1]

I don't know VBA, so I guess I'm screwed.

I guess I'll head over to the VBA forum unless your a genius & know how to free hand VBA code.

[davesexcel]

Create a ComboBox and a Button from the Controls toolbar,
Double click on the button and place this code there

Please Login or Register  to view this content.

[g00glethis1]

Your a genius. The code works great!

Now, How how do I declare the range row 6 ("6:6") from another worksheet named "Data" (i.e. Sheet 2) within the same workbook?

[g00glethis1]

Also, I'm looking for a way to sort the data by Name Ascending.

[davesexcel]

This thread has some code to sort a combobox, i just tied it into the populating code,with a slight change the the source range.

http://www.excelforum.com/excel-prog...box-items.html

Please Login or Register  to view this content.

[g00glethis1]

The sort by Name Ascending works perfect!!!

So how do I pull that range from another worksheet (i.e. Sheet2 ("Data")) within the same workbook/file because the combobox needs to stay on Sheet1(Formula)?

[davesexcel]

try this out

Please Login or Register  to view this content.

[davesexcel]

Post 10 Moved here
http://www.excelforum.com/excel-prog...-combobox.html