populate sheet based on criteria selected in userform combobox.

Good Day

I have a userform with 2 x comboboxes and one textbox.

combobox1 is populated from Sheets("Lookup") Range("B2:B300")
combobox2 is populated from Sheets("DATA") Range("B3:B7")

There are multiple iterations of the values in Sheets("Lookup") Range("B2:B300") in column C of Sheets("DATA")

What i need is the following, the user selects a value in combobox1 and combobox2 and manually enters a value into textbox1 and then presses commandbutton1.

The code then needs to search for the row in DATA sheet where combobox1 and combobox2 values are in column B & C next to each other and then enter textbox1 value into column D of the same row.

Not sure if it makes any difference, but DATA sheet column B is dates formatted as yyyy/mm/dd. I would also like for this to show in the combobox2 as the same format, but is does not....currently i am using the below to add the dates to the combobox.

Please Login or Register  to view this content.

As always, any help will be greatly appreciated.

Thank you very much Alpha. You Rock!!!!