09-12-2002, 02:30 PM
|
|
Just another Excel nerd
Retired Moderator
* Guru *
|
|
Join Date: Feb 2000
Location: Michigan, USA
Posts: 2,624
|
|
Lesson 3 - Having items in one ComboBox filter items in another ComboBox
For this example, I'm not really using a ComboBox. I'm actually using the Validation option programatically.
When the user changes the company in cell B1, cell C1 will automatically have a Validation to make sure that only employee names from that company are shown.
To do this, I the following code in the code of Sheet1:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
FilterList
End If
End Sub
|
__________________
"The face of a child can say it all, especially the mouth part of the face." - Jack Handey
|