reproduce code by array & fixing unspecified error

[ABDELFATTA]

hello
I need help to fixing this unspecified error

when I run the userform shows data based on last entered date and when I try searching for item based on column B by using textbox will populate unspecified error in this line

Please Login or Register  to view this content.

and if it's possible reintroduce the code by array to make decreasing code slowness if the data are huge.

Please Login or Register  to view this content.

thanks

[Marc L]

Hello,

and if you move this codeline one line down ? …

[sintek]

Give this a go...Start typing in textbox..

Please Login or Register  to view this content.

[ABDELFATTA]

@Marc L i don't understand you

[ABDELFATTA]

@sintek thanks , but just I want the code for textbox1 . I want keeping the code on Private Sub UserForm_Initialize() without any change
I try using the original code for Private Sub UserForm_Initialize() , but gives compile error variable not defined in this word CntLatestDt for this line

Please Login or Register  to view this content.

[sintek]

Ok, I see you only want latest date in listbox...
This solves...

[ABDELFATTA]

much appreciated ! thanks for your solution

[sintek]

I could easily have just fixed yours but you would have run into issues down the line...
Pleasure...Glad I could assist...Post 6 file has been updated with simplification...