CommandButton and FIND fails

[JBeaucaire]

Haven't done a LOT with forms, but this should work (in my mind) and doesn't.

I'm using a ComboBox linked to a named range of "DATES" for a user to select a date. All I want to do is find that date in column A of the Sheet1.

Please Login or Register  to view this content.

Eventually I'm going to link all the text boxes to the sheet1 data and let them load up the existing value by date, make changes, then save them back to the original location.

But it ain't working and I'm scratching my head.

I really just need the red or the blue code to return a value so I know what row to take from/send to, I can take it from there, but right now they both come up empty.

Thanks in advance for the assist.

[pike]

Hi JBeaucaire
have a look at these two values

Please Login or Register  to view this content.

[DonkeyOte]

FWIW when looking for dates in a Match I generally use the CLng(date) as the criteria.

[pike]

Does this work for you..

Please Login or Register  to view this content.

[JBeaucaire]

No, none of that helps. Try clicking on the form button, selecting the first date in the list, then clicking the LOAD FROM DATABASE button. Nothing ever works.

I've also tried NOT formatting the selection in the Date1 box, leaving it as raw datevalue, no help.

[Andy Pope]

This works for me

Please Login or Register  to view this content.

Although US date format may need a change to the dd-mmm-yyyy mask.

[pike]

Very strange both work this end
What results did you get in the immediate window?

[JBeaucaire]

Although US date format may need a change to the dd-mmm-yyyy mask.

The tweak to date format in the other sub did the trick. Thanks Andy!

And thanks all for helping me. Very frustrating the *little* things, huh? Here's the finished utility if your interested