Excel 2010 VBA Tutorial 70 - Global Variables

[peter]

Fantastic explanation, this will make such a difference to mu code. Thanks so much

[paranguaricutirrimir]

Very good video, you're helping me so much. Thanks!

[MrZocker]

Thank you very much. I didnt expect ist taht easy, but noone ever made a Video saying that. So thank you!!

[REgamesplayer]

Hey again. I do not know where to post, I just wanted to ask you a question about the excel. On occasion excel does weird stuff which program should not. For example, it gets stuck in the loop of making a word in a bold format and it removes said formatting. Code in itself is not an issue, because most of the time it runs without an issue. Compiler just gets stuck in infinite loops on a whim. Then there are issues of where you place your mouse cursor in a sheet. I had noticed that compiler on rare occasions start to work differently like printing values in slightly other position in a sheet. Code in itself is not reliant on active sheets or mouse positioning and most of the time it works regardless of what I do on a sheet.


Do you encounter yourself such simply bizarre issues while working with VBA?

[ieatpie]

This is a module variable, not a global variable

[REgamesplayer]

Doesn't work anymore. VBA requires declaration of variables first.