Need Help ASAP Please! - ComboBox2 List Value based on what 1's Value

[kfdavis512]

I'm hoping you guys might be able to help me meet a deadline in helping me solve how to code this.

Essentially:

Combobox1 = The names of each sheet in Workbook

Each sheet is titled after a state. Example: "Arizona" "Texas" "etc."

Now I have that part down but I'm having trouble with Combobox2's value. This is what I'm trying to populate:

Combobox2 = Based on what state is selected for ComboBox1, pull each name in that state's assigned sheet Range("A2:A200")

But each name that is in Range("A2:A200") is duplicated various amounts of times throughout the sheet. I'm looking for Combobox2 to only display Unique Names within the range.

Please, if you guys can help get this solved as soon as possible that would be amazing!!! <3

[bakerman2]

An example file might help speeding up things a little.

[kfdavis512]

Unfortunately it has to deal with a lot of personal information so I'm hoping this explanation might help out a bit. =)

Workbook Sheet Names: Arizona, California, North Carolina, Ohio, Tennessee, Georgia, Missouri, California, Florida, Illinois, Nevada, Pennsylvania, Texas, and Washington.

Inside Each Sheet:
Column A: Provider's First/ Last Name - Column Titled: Provider
Column C: Payer's Company Name - Column Titled: Payer

UserForm Info:
ComboBox1: This is the first selection available to the searcher. The names displayed in the UserBox are the name of each Worksheet in the Workbook. They are titled in correspondence to the specific state info for each sheet.

ComboBox2: This will display the First/ Last Name of each provider, listed in each cell within Range("A2:A200"), in correspondence to the sheet name chosen in Combobox1.

***

This is where I'm having the problem. I can get ComboBox1 working to populate each State but ComboBox2 I can't seem to get working. Let me know if this helps and any points I can help clarify!

[bakerman2]

In Worksheetmodule.

Please Login or Register  to view this content.