isdate

Hi, would like to ask theres a alternative function/formula for ISDATE? Here is my problem: Cell A1 = 12/RE/2022 (which is supposed to be a date format but it contains a text, where ISDATE is the only one can solve i think) as a starter i hope you can share me some ideas thanks!

For some reason, IsDate is missing some blank cells and I can't seem to resolve the problem. The blank cells have been thoroughly checked with IsBlank and IsEmpty and show as blank cells. What happens is, the blank cells are then subtracted from a date and consistently return a -43524...

Struck a problem in my macro... I have a string Variable (VarType=8). It's value is, e.g. 04 51 and IsDate tells me True. It's not a real Date, it's a Time Duration (4 mins 51 secs). Excel may interpret it as a Date, but I don't want it to unless it's 'dd mmm yyyy' Format. The variable is...

Can someone please tell me the correct syntax when using the "If Isdate" command when referencing a range in another worksheet that is not active? I've tried a variety of guesses and none work, such as "If Worksheets("Inactivesheetname").Cells(3,1). isdate then". Yes, it makes no sense, but...

Hello all, I am a definite newby to all this, so please be gentle with me! I haven't done programming really since back on the Commodore 64. Some of this seems intuitive, some just does my head in. I have the following code: Sub GetDate() 'set colours for pass/fail validations ok = 42 notok...

I have three blank text boxes in a UserForm. All of them should not be blank, or It gets message 'Fill All of Them' and also, if the value in the third text box is not a Date format, I want a message box "Enter A Date" Somehow,, my code is not working.. Please somebody help me out.. ElseIf...

What works best? IsDate? I am semi new to VBA and have only performed basics and I have something that has stumped me. Description: This one has a bit of everything involved. I need to write/modify a VBA macro that can paste special value depending on if the date matches. In otherwords...