Store date and time in a variable in Mac Excel 2011 vba

[uni9e]

I have been able to do it fairly easily in Windows using the code

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit;">dim timeVariable as datetimeVariable = now()</code></pre>Now, I was able to view the date and time stored in this variable using the Watch window. However, when I try to do the same in the Mac Excel 2011, the value of the variable in the watch window is blank.
I know this seems to be a simple query and I tried to google it out but could not find any solutions.

 

[Jim Gordon]

Use this

Dim timeVariable As Date
Let timeVariable = Now

Use this: