Greetings,

I have a UserForm with 3 ComboBoxes and several TextBoxes. I also
have 2 worksheets called 'Data' and 'List'. 'Data' is the records
database and 'List' is the named ranges storage.

I am attempting to edit the records on 'Data' by using a UserForm
setup to find a certain 'Item Number' from a certain 'Vendor' on a
certain 'Date/Time'.

On sheet 'Data', column A is the 'Vendor' name, column B is the
'Date/Time' entry and column C is the 'Item Number'. These columns
are also named ranges. Column A is 'dVendor', column B is 'dDate' and
column C is 'dNum'

On sheet 'List' is a named range of unique vendors called 'lVendor'

On the UserForm are 3 ComboBoxes: Vendor Name, Date/Time and Item
Number. There are also a few TextBoxes (the exact number is not
relevant).

ComboBox 1 gets it's RowSource from 'lVendor'. ComboBox 2 RowSource
is dependent on the value of ComboBox 1, but not referenced to
'lVendor' (the named range on 'List' with the unique list of names),
but referenced to 'dVendor' (the named range on 'Data'. 'dVendor'
does NOT have a unique names list of names, but many duplicates).

I have got as far as ComboBox 1, but I can't seem to find a way to get
the RowSource's for the next 2 ComboBoxes. The TextBoxes need to be
filled from the results of the three ComboBoxes. I was thinking of
either VLOOKUP or OFFSET finding the row that matches the ComboBoxes
results and getting the correct column for each TextBox.

I have looked at a few of the Data Validation solutions and I can't
figure out how to make any of them work.

I have been searching for answers in the news groups, chasing down web
sites, going though the code that was submitted, for the last 4 days
(there are a lot of solutions to go though, just nothing that I can
use).

Does anyone have any ideas on how to accomplish this?

Any help is appreciated!!!!

Thanks for looking at my post and any help you may be willing to
render.

-Minitman