You wouldn't need the case statement - it builds the defined name base on
the vlaue of combobox5


Again, this only works if the first 3 letters of each selection in the
combobox5 would build the proper defined name.


Assume the choices are in combobox 5 are

AAAAAA
BBB
CCC/DDD
EEEEE
FFF-YYY-ZZZ

then using this method, you would build names like

Branch_Name_AAA
Branch_Name_BBB
Branch_Name_CCC
Branch_Name_EEE
Branch_Name_FFF

This fit the pattern for the four names (two Combobox5 values) that you
showed. I can't guess what the other ones are, but just suggested an
approach which doesn't require a case statement with five different
conditions (if you use consistent defined names).

--
Regards,
Tom Ogilvy


"Scot Rundell" wrote in message
...

-----Original Message-----
Combobox5.ListFillRange = "Branch_Name_" & left
(Combobox4.Value,3)
ComboBox2.ListFillRange = "Estimator_" & Left
(combobox4.Value,3)

would be simpler if you set up your names to correspond.

If you didn't, then you can go ahead and use redundant
code.

--
Regards,
Tom Ogilvy



Scot Rundell wrote in
message
...
Thanks for the help, but this is what I ended up
using....
Select Case ComboBox4.Value
Case "VIC/TAS"
ComboBox5.ListFillRange = "Branch_Name_VIC"
ComboBox2.ListFillRange = "Estimator_VIC"
Case "QLD"
ComboBox5.ListFillRange = "Branch_Name_QLD"
ComboBox2.ListFillRange = "Estimator_QLD"
End Select

Regards,
Scot Rundell



*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!


.
Is this code used inside the case statement or is it
seperate?