Type Mismatch Error - How to Fix

Hello Experts

I have a workbook & containing two worksheets sheet1 & sheet1, i am trying to copy data between two dates through userform1. textbox1 & textbox2

but i am getting error " type Mismatch " Please let me know how to fix this error

Part code which is highlighting Type mismatch & wanna to fix

Please Login or Register  to view this content.

Full Code

Please Login or Register  to view this content.

The sample sheet is attached for your ready reference.

Help in this line will be highly appreciated

Thanks in advance

Vaibhav2312

or

Please Login or Register  to view this content.

Hello Winon & nilem Sirs

Awesome, superb,

The Both codes are working perfectly, As i wanted

Thank you very much for your immediately response


Vaibhav2312

Hello vaibhav2312,

You are welcome. Glad your issue is solved.

Hello nilem & Winon Sirs

Thank you very much for your help

but i am facing new problem, if i am using nilem's code & date contains on column on E the data not copying
please look in to & help me out.

The Same workbook is attached for your ready reference.

Code of Nilem

Please Login or Register  to view this content.

Thank in advance
Vaibhav2312

just change this line (column "E" - is the 5th column)

Please Login or Register  to view this content.

Thank you very much sir

Working perfectly as i wanted


Thanks many many times
Vaibhav2312

@ vaibhav2312

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Thank very much sir.

It will never happen again.

Thank you