Compile error message not showing

[jonnyyyl]

I'm using Office 2016 64bit

I am making a real effort to learn VBA. One of my exercises asks me to declare something as follow:

cells (1,2) = yournam (the correct variable is yourname)

when running it, I am told to expect an error message due to the above typo, and I should receive "compile error: variable not defined"

The program ran perfectly fine, and skipped the cell(1,2) command. No error window showed up.

I am not sure what went wrong..?

 

[MarvinP]

Hi jonnyyyl,

I'd bet the instructions have an "Option Explicit" as the first line in the module. This would then give you an error message.

 

[jonnyyyl]

come again??

 

[GTO]

Exactly as Marvin says, if you include "Option Explicit" (minus the quote marks) at the top of each module, then the Compile Error is created, as Option Explicit insists that all variables be declared. Without Option Explicit, yournam is implicitly declared as a Variant and later sub-typed if/when a value is assigned to it. In Help, you can enter "Option Explicit" and the topic will show.

Hope thta helps,

Mark