Using combobox to replicate database operations in a user form

Hello - new user to both the forum and VBA here.

I'm trying to use a combobox on a user form to find then change data in an excel sheet. Basically the functioning will be the same as the MS userform however not everyone that will use the form will be able to access the MS form easily and it requires typing which I'm trying to restrict ( by using combo's).

So I'm trying to replicate that form but have drop down boxes to change the cell values. I've been at this for 2 days so far and have searched far and wide to find a solution by hacking bits and pieces of code together. This is what I have so far:

Please Login or Register  to view this content.

On opening the form the combobox1 defaults to todays date (which is cell AC1). On running the find routine it presents the correct data, once a new date is selected from combo1 and the find routine run it gives a "Not listed" message box (as it should if it cant find the right result). The data it should be looking at is in A2:A32 on the same sheet.

Finding the right data is the first issue - changing and writing it to the correct cells will be the next one

I'm unable to attach the file, too big and sensitive information etc.....

Any responses much appreciated.

Regards
Kranky

Ok sorted the first issue ( dates not being found) by setting the formats the same. Simple really.

Please Login or Register  to view this content.

Got some working code happening, this is the full thing:

Please Login or Register  to view this content.

here's a screen shot of the form:
Screenshot.jpg

however: Once the form is unloaded then loaded again it cannot find anything from ComboBox1. Is there anything I need to do to fix this?

The code for command Button 2 is horribly slow by the way.

Regards

Kranky

Well have since built another that works (for a different form),

Please Login or Register  to view this content.

works first time every time but just can't adapt it to this application. Would really appreciate any guidance what so ever.

Date handling issue which I'd presumed it was. My inelegent solution is:

Please Login or Register  to view this content.

thanks for everyones input