isdate

  1. J

    IsDate macro missing some blank cells

    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...
  2. A

    IsDate

    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...
  3. B

    Worksheet Reference with If Isdate

    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...
  4. D

    Trouble using isdate and checking if cancel pressed.

    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...
  5. K

    Can anyone fix my code using If and ElseIF?

    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...
  6. S

    IsDate, Paste Special Question...

    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...

Some videos you may like

This Week's Hot Topics

Top