Hi All
I have a simple loop looking for a date in a column based on whatever is typed in the Text Box in my user form, I know the date is there but it just keeps looping past it. I have tried testing putting in a simple number “5” and searching for that and again it fails. Is there any other tests I can do ?
My loop code
Thanks Dan
I have a simple loop looking for a date in a column based on whatever is typed in the Text Box in my user form, I know the date is there but it just keeps looping past it. I have tried testing putting in a simple number “5” and searching for that and again it fails. Is there any other tests I can do ?
My loop code
Code:
Rng = UserForm3.TextBox1
Range(“A1”).select
Do Until ActiveCell.Value = Rng
ActiveCell.Offset(1,0)
Loop
Thanks Dan