variable scope

I want to monitor when a value changes of several combo buttons on a user form. I have set this up using a class module to capture all the comboboxes on the userform. I have the following code in a class module called “ModComboClass”: Public WithEvents ComboGroup As MSForms.ComboBox Public Sub...

I'm having a hard time understanding how Public variables declared in an Excel workbook retain their values. Every source I can find suggests that all variables declared as "Public" store values that are available to all procedures across all the workbook modules. These Public variables are...

All, I am trying to write a simple piece of code and across multiple procedures, I'm trying to find the bottom row of a range (e.g. Cells(65536, 1).End(xlUp).Row I'm not having any troubles with this. My question is that to simplify the code, and to speed up changes, is there a way I can make...

My knowledge of VBA is fairly specialized so a lot of the fundamentals aren't quite clear, but this is what I understand about the lifetime of variables and their scope: A Public variable declared at the top of a module is available to all modules and procedures within that workbook...