The down & dirty....
I have a register for inventory (in this case, animals), & I'm trying to create a form that will ease the input of new items.
First, the database....
Sheet1 has three columns, A, B & C
Column A is the type of animal (ie, cat, dog, horse)
Column B is the Breed
Column C is the Name of the pet.
On the Userform I'm trying to make, I have two comboboxes (one for animal & one for breed) & one text box that & will type in the name.
Here is my question. Once I've selected the "animal" (let's say dog, for this instance) from the combobox, what code do I need to only display the "breeds" associated with dogs.
In more Excel terms, I need for breedcombobox to show only the values of sheet1's column B if column A's value equals animalcombobox's value.
I'm guessing it's a countif function, but I'm stumbling with no sign of recovery.
I'm greatful for any replies.
I have a register for inventory (in this case, animals), & I'm trying to create a form that will ease the input of new items.
First, the database....
Sheet1 has three columns, A, B & C
Column A is the type of animal (ie, cat, dog, horse)
Column B is the Breed
Column C is the Name of the pet.
On the Userform I'm trying to make, I have two comboboxes (one for animal & one for breed) & one text box that & will type in the name.
Here is my question. Once I've selected the "animal" (let's say dog, for this instance) from the combobox, what code do I need to only display the "breeds" associated with dogs.
In more Excel terms, I need for breedcombobox to show only the values of sheet1's column B if column A's value equals animalcombobox's value.
I'm guessing it's a countif function, but I'm stumbling with no sign of recovery.
I'm greatful for any replies.