Hi All,
Can anyone please help me out with the correct method of passing values from a UserForm to the Module (written codes)?
I just want to load the UserForm & run the codes via using shortcut keys (Ctrl + k), so this methodology can give me a freedom to run the codes on any worksheet, which is active.
Please see my codes and help me:-
I am unable to populate all the worksheet names in a list box by UserForm_Initialize.
I am unable to pass values from UserForm to the module. I Just want to setect anyone of them in the ListBox, so that the Module codes {Variance_Finder} should be run on that paticular worksheet
I tried with a TextBox too instead of the above ListBox. It shows me the ActiveWorksheet Name, where I want to run my codes via shortcut keys (Ctrl + k), but the appeared worksheet name doesn't passes from UserForm to the Module, so the codes do not work at all.
Please help to have a perfect tuning between the UserForm and Module Codes.
Thanks in advance!
Please see below, is the attached sample in MS Excel 2007:
Bookmarks