Having a blank day
A change event in a combobox increments a counter and then calls a procedure in a module.
The procedure in the module compares the value of the variable with an if statement and if appropriate initiates a msgbox before returning to the userform.
I have declared the counter variable in the module as a Public variable but the variable loses it's value when the called procedure in the module is run.
Have tried to declare the variable as private and global but it doesn't work either.
A change event in a combobox increments a counter and then calls a procedure in a module.
The procedure in the module compares the value of the variable with an if statement and if appropriate initiates a msgbox before returning to the userform.
I have declared the counter variable in the module as a Public variable but the variable loses it's value when the called procedure in the module is run.
Have tried to declare the variable as private and global but it doesn't work either.