-----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?