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

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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top