one combobox affecting another
Hi,
I have 2 comboboxes ("Business" and "Name"). When Business is selected I
would like Name to populate with all the names on the sheet that is named
Business.
I have tried the following code but get an error message saying that Name is
an invalid qualifier. Can you change one comobox with another or is my code
just flawed?
Private Sub Business_Change()
Sheets("" & Business).Select
Range("E7").Activate
While ActiveCell < ""
Name.AddItem ActiveCell.Value
ActiveCell.Offset(0, 1).Activate
Wend
End Sub
Thanks for any help you can offer.
JohnP
|