Good Afternoon, I have been doing a lot of work on userforms but have been asked if i can create a drop down that will automatically update agents in a spreadsheet I have all the manager names and agent names in another sheet to reference but I am unsure how to get them show on a spreadsheet. I have previously used vb like below for userforms If ComboBox1 = "Billing (EC)" Then Feedback.ComboBox2.AddItem "Account merged in error" Feedback.ComboBox2.AddItem "Aquaisition Read not Used" Feedback.ComboBox2.AddItem "Annual Statement - Tariff" Feedback.ComboBox2.AddItem "Billing Language" Feedback.ComboBox2.AddItem "Disputed Bill" End If

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Updating cells dependant on info

Thread starter gmazza76
Start date Aug 22, 2011

gmazza76

Well-known Member

Aug 22, 2011

Good Afternoon,

I have been doing a lot of work on userforms but have been asked if i can create a drop down that will automatically update agents in a spreadsheet
I have all the manager names and agent names in another sheet to reference but I am unsure how to get them show on a spreadsheet.
I have previously used vb like below for userforms

Code:

If ComboBox1 = "Billing (EC)" Then
        Feedback.ComboBox2.AddItem "Account merged in error"
        Feedback.ComboBox2.AddItem "Aquaisition Read not Used"
        Feedback.ComboBox2.AddItem "Annual Statement - Tariff"
        Feedback.ComboBox2.AddItem "Billing Language"
        Feedback.ComboBox2.AddItem "Disputed Bill"
End If