View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default How Do I Load A ComboBox RowSource From The Results Of Another ComboBox

Greetings

I have 2 ComboBoxes on a UserForm called CBox1 and CBox2. CBox1 works
fine. It looks to get 1 of five names. I have five named ranges with
the same names as the five choices that CBox1 can choose from. I need
for CBox2 to load the named range with the same name as CBox1's
choice.

I tried but it would not accept my entry into the RowSource property.

Is this even possible?

Any help would be most appreciated.

TIA

-Minitman