Multiple Range in UserForm ComboBox Error

[Faridwahidi]

Hi,

Can pls help me? I am really confused

this code working fine.

Please Login or Register  to view this content.

While breaking point below not working,

Please Login or Register  to view this content.

[lancer102rus]

because RowSource didn`t accept disjoint ranges

[Faridwahidi]

Hi lancer102rus ,

So, How to resolve it.

I have been trying use .List & .Value but enitre of my code having problem, thus I tried .RowCourse & .Address , but there is a problem in multiple range selected.

[lancer102rus]

is there a problem to use Range("I2:I4") in RowSource?

[:) Sixthsense :)]

Instead of referencing the rangeS, just add the datas it in the combo box via looping system

[Faridwahidi]

Hi sixthsense,

I'm not familar with looping, I have tried this but got error,

Please Login or Register  to view this content.

I just want to select "I2" & "I4".

On another cases, I need to select "I2" & "I7:I11"

[:) Sixthsense :)]

Please Login or Register  to view this content.

Change this

Set ws = ActiveSheet

to your actual sheet reference

[Faridwahidi]

Hi sixthsense,

Thanks for looping technique.


I am a bit confused, ws supposed to be referred to Worksheet("Data"), whereby the data is stored?

Activesheet is the worksheet to populate the data? if I use ws.Range("I2", "I7:I11") as activeSheet there is no data found.

With Me.ComboBox___ is refer to the box to be filled in or previous box as this is dependent drop downlist?

[Faridwahidi]

I have resolved it by using

Please Login or Register  to view this content.

Anyway, thanks a lot

[:) Sixthsense :)]

Please Login or Register  to view this content.

[Faridwahidi]

thank you so much