Checking if date value in cell is between or equal to start and end date

Hello,

I am currently working on a vba code to loop through a list of cells, A6:60, but I have been unable to get my code to validate if the cells in this range are between or equal to the data entered by the user in a textbox. I have found that if do not attempt this, the rest of the code works perfectly fine, as such I have only included the basis that I have been having issues with.

My current code is as follows:

If Datetxt ">=" dtStart And Datetxt "<=" dtEnd Then
'Here I have entered data that will send the data to its separate sheet
else
MsgBox "The data has been tranfered to the worksheet 'Summary'."
End If

'The cells will continue going up here through code until a blank cell is past and the list is through
If IsEmpty(ActiveCell.Value) Then
MsgBox " I'm sorry, there was no job found on that date."
End If


' the value of Datetxt = the activecell.value



I have been working on this problem for days and have been unable to fix it. And it must be in VBA.
Any and all assistance on this would be greatly appreciated!

Sincerely,
Rebecca

Please Login or Register  to view this content.

I seem to be continually getting an error,

If ((datetxt >= dtStart) And (datetxt <= dtEnd)) Then
MsgBox datetxt
Else
Msgbox "Testing"

No matter how I use this equation, I am still getting the same "Testing" message.

Put a debug on it, in VBA editor click the little column to the left of the Function or Sub name, that should insert a brown circle. Then do what you normally do but it should stop at the point of running this code, you can then step through it using F8 and monitor the variables (switch on the Locals and Immediates windows) or simply hover over the variable names at each step to see what they're populated with.