kieran989
03-03-2017, 08:22 PM
Is it possible to declare and set public variables such as worksheets and ranges in a module, and then refer to these in userforms?
I have declared several public integers, worksheets and ranges in a module. Then set the worksheets and ranges in the same macro that shows the userform.
The userform code still wont recognize the named ranges and worksheets?
I have declared several public integers, worksheets and ranges in a module. Then set the worksheets and ranges in the same macro that shows the userform.
The userform code still wont recognize the named ranges and worksheets?