VBA Macro only works when manually put the information

So have made a data entry userform, to add the information on the sheet. the thing is when I put the data through it, the information seems to not "exist" to others macros, Unless I put the data manually.

Please Login or Register  to view this content.

EDIT:

this code refer the cell with date. I cant figure out. Basically my code revolves around the date so, if i manually put the date it work, If I put through the data entry I am unable to run others macro, because it can't read the date..

Please Login or Register  to view this content.

Tried:

Please Login or Register  to view this content.

still can't fix it

I expect that CBDA is just a textbox. So it's value is a string, not date.

You tried to convert it to date with CDate, but then immediately converted back to string using Format.

So may be just

Please Login or Register  to view this content.

will be fine.

But as you written in a profile that your location is "Europe" your local settingd could be quite different. So make sure you enter the date in a CBDA as string following your regional settings.

Other options could be:
a) use a calendar control for date input
b) use separate textboxes (or may be dropdown lists) for day, month and year and compose a date out of these elements.

Originally Posted by Kaper

But as you written in a profile that your location is "Europe" your local settingd could be quite different. So make sure you enter the date in a CBDA as string following your regional settings.

Other options could be:
a) use a calendar control for date input
b) use separate textboxes (or may be dropdown lists) for day, month and year and compose a date out of these elements.

It has been fixed with your help.

Since we are talking about date and you actually talking about something I am trying to understand , If you dont mind explaing a bit more further.

So was doing userform filter date which(dante helped me a lot) he used Cdate which is completely new to me, and most of the time the date showing on combobox is mm/dd/yyyy, sometimes it get my pc format date dd/mm/yyyy it's unstable can make some confussion to the users. Not telling your to fix just need some insight