Rowsource in combobox

[kelly mort]

Hello,
I want to load my comboboxes dynamically.

I have four comboxes and I am loading them with I rowsource.

What I want to do now is that, when I select an item from the first combobox, then inside the second combobox, show the list from the first combobox except the one selected in the first combobox . Then inside the third combobox, show the list from the second combobox except the one selected from the second combobox etc.

I hope this is achievable.

Thanks

Kelly

 

[kelly mort]

Re: Rowsource in combobox challenge

Here are two example of Arrays

Private Sub CommandButton2_Click()
ComboBox1.List = Array("One", "Ten", "Twelve")
ComboBox1.List = Array(Cells(1, 1).Value, Cells(5, 1).Value, Cells(7, 1).Value)
End Sub

Oh great can you explain what the above lines are actually doing please?

Regards
Kelly

 

[My Aswer Is This]

Re: Rowsource in combobox challenge

They are loading values into your Combobox

The first example loads "One" and "Ten" and "Twelve" into your combobox

Or if you wanted to load cell values into your combobox you can use the second example.

 

[kelly mort]

Re: Rowsource in combobox challenge

Okay nice so with the first one, if I want to swap those list for another like I do for the rowsource by setting
ComboBox1.Rowsource = "", how will that be done?
Regards
Kelly

 

[My Aswer Is This]

Re: Rowsource in combobox challenge

These are the two example:

ComboBox1.RowSource = "A1:A20"
ComboBox1.List = Range("A1:A20").Value

My First example would normally only be used for a small amount of values.
Unless you want to enter 20 more values Like "Apple" "Cake" "Pie"

But there are ways to use arrays to do a lot more things. I'm not sure how to do what is know as two dimensional arrays.

 

[kelly mort]

Re: Rowsource in combobox challenge

Okay thanks a lot for the time.

I will be back here again when I get tougher challenge

 

[MARK858]

Re: Rowsource in combobox challenge

Kelly, have a read of the links below if you want to learn about arrays....

http://www.snb-vba.eu/VBA_Arrays_en.html

https://excelmacromastery.com/excel-vba-array/

 

[kelly mort]

Re: Rowsource in combobox challenge

Wow that's a lot of information for me there. I am grateful for it.

Thanks