This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
I am wondering if this same issue arises on a Windows platform.
If I Dim dates the last variable of the dates always wants to assume a Time format and appears as String*-1. All the others become Variant/String*-1. So this last date variable does not function as a Date variable in the normal fashion. I haven't tested but it seems to be a Time. I'm not sure my screen shot is uploading properly but its very straight forward. This is very strange behaviour and quite confusing. Always must declare a dummy date to get around it.
Dim Date1, Date2 as date
then in watch window
Watch : : Date1 : 2020-12-24 : Variant/String * -1 : Module7.ShowDateTimeIssue
Watch : : Date2 : 00:00:00 : String * -1 : Module7.ShowDateTimeIssue
I don't know why the Watch window shows Date1 and Date2 as strings. Perhaps Mac stores dates as strings?
But I can explain the difference: in a Dim statement, you have to specify the data type of each individual variable, otherwise they default to Variant. So the line
Dim Date1, Date2 As Date
is equivalent to
Dim Date1 As Variant, Date2 As Date
If you want to declare both as dates, use
Dim Date1 As Date, Date2 As Date
Thanks your clues gave me some answers. However its strange because the MS DOCS on DIM say that Dim x, y as DATE will declare both. But as you say it does not.
In my case the variables that do work are in fact the variant variables. The DIM is actually calling the final variable a STRING. Experimenting with Single, Double and Integer it gets even more bizarre. The last variables in the DIM line can not be used as numbers while the variants can.
Dim x, y as Integer will give an error 6 if you try to assign a value to y, but x is OK.
Obviously this is a MAC issue, except for the seemingly faulty info out of the MS DOCS suggesting Dim x,y,z as integer etc is OK. You must of discovered this by experience not from the DOCS. Not allowing that makes no sense and in my former programming experience is very strange indeed.
Thanks
See for example viewtopic.php
Ah now I see it in the documentation. An earlier reply to you put me onto it. I was looking at the same article not realizing it was VB, not VBA.
type Optional. Data type of the variable; may be Byte, Boolean, Integer, Long, Currency, Single, Double, Decimal (not currently supported), Date, String (for variable-length strings), String length (for fixed-length strings), Object, Variant, a user-defined type, or an object type. Use a separate As type clause for each variable you declare.
https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dim-statement
Thanks, it’s always nice to get the right answers.
OK now I've got that sorted out it seems that MAC vba is very limited when it comes to data types. Thanks to my not realizing that every variable in a DIM statement must have a matching "as"; most of the variables I was using in a rather large project for the past 10 years ended up as variants. The project runs on a Windows machine but I have been using a MAC for about 5 years and was able to run it on both. Recently when making some changes to the code however I started to see some issues: (Error 6)