Noncontiguous Range for ComboBox Row Source

[wandan]

Hi There,

Is there a way to set the row source for a ComboBox to a noncontiguous range? I need the selection options to vary based on certain criteria. So, sometimes it might be just "A1", but in others it might be "A2,A3,A6", etc.

I have found how to create a noncontiguous range (ie. Range("A1:B8,D9:G16")), but I cannot figure out how to assign it to the row source.

I am using a UserForm in Excel 2003.

Thanks.

 

[SkipVought]

Hi,

You do that by returning a contiguous list based on a dynamic criteria.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wandan]

Ummm... how do I go about doing that exactly???

 

[SkipVought]

Check out faq68-5829.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}