Should I use an IF statement?

I have a userform where the user can type in info, choose a date in the combobox, and press OK. What i need is a code for the program to automatically find the date in my spreadsheet and put in the information in that row.

What i have now is this: the code finds the next empty row and enters the info.

Please Login or Register  to view this content.

But I really need a way for it to match the date from the combobox to the same date on my spreadsheet and select that cell on the spreadsheet! Will I be able to use an IF statement? If so, can u provide an example? Thank you.

Originally Posted by okriskao

Ok Thanks, I'm going to do that now, the reason I posted on 2 forums is cuz I posted a question before on exceltip and nobody answer, i figured the chances that someone will answer will be higher if i post my question on more forums.. i hope you are not mad! Thanks for your help!

This is what annoys members who answer your posts on one Forum then see it on another. Read the Forum Rules, cross posting is explained there.