Save Button and Search On Userform faults

**flyinghigher2011** · 07-20-2013, 05:33 AM

i have the following code which is from my Search Expenses page on my userform, i have a search by date as well as the listbox. if i put a date in and press search it populates a set of boxes and the same from the listbox. my issue is this, when i edit the item which it allows me to day it throws up saying that the item can not be found yet its put the item in the edit section

im just wondering if there is a problem with my search date and save buttons, could someone help please

Please Login or Register  to view this content.

**Tinbendr** · 07-22-2013, 11:42 AM

I don't know if this is your problem, but there's an article about searching for dates. (Scroll to bottom)

**flyinghigher2011** · 07-22-2013, 12:03 PM

i suppose but very confusing since im new to this

**Tinbendr** · 07-22-2013, 12:49 PM

So the article describes that searching for a date must be in a specific format "mm/dd/yyyy".

F8 to step through the code and after it passes datFind = DateValue(sFindIt), hover over datFind and see what number it's assigned. Then go back to the worksheet and format the date in question to General. This number in the cell should match the number in datFind.