Hi Dev Community,
I have been trying to locate a way to pass a variable or call a sub routine of an Excel 2002 VBA Userform, and so far i've been stifled.
The functionality that I seek is as follows: Using a macro(s) to call a single UserForm routine. When this single routine is called from different Excel cells I will to test a case and have the function operate in different ways relative to the case statenents.
Can you list members provide me with ideas on how I can or if I can achieve this type of funtionality?
Your thoughts are much appreciated.
Truly,
Steve
I have been trying to locate a way to pass a variable or call a sub routine of an Excel 2002 VBA Userform, and so far i've been stifled.
The functionality that I seek is as follows: Using a macro(s) to call a single UserForm routine. When this single routine is called from different Excel cells I will to test a case and have the function operate in different ways relative to the case statenents.
Can you list members provide me with ideas on how I can or if I can achieve this type of funtionality?
Your thoughts are much appreciated.
Truly,
Steve