Find UserForm ComboBox Value (date) & Transfer TextBox Data To Same Row

Hi all

While doing a project, I found the first file on a forum. It lets me choose an alphabet (in combobox on userform) and finds it in the spreadsheet. It then transfers the data I entered in the textbox (on userform) to the same row (on worksheet) of the alphabet found.

What I am trying to do is change that alphabet into a date. I have managed to do that format in the combobox but when I try to get it to find the date on the spreadsheet, it just gives me an error saying "Compile Error: Sub or Function not defined". It gives me that error box only after i click on the arrow in the combobox and click on a date. I am pretty new to macros and will really appreciate some help. Thanks in advance

If you do not receive a reply and your question is clear you can bump your thread to bring it to the top.

Please Login or Register  to view this content.

OMG! U are awesome!! Thank you so much!!

By the way, are you the same Andy Pope as the one who wrote some hacks in OReilly Excel Hacks book?