Pass values from UserForm ListBox/ TextBox to run the codes of a Module

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:

Thank you for ur quick reply and help!!

It is working; but when I use Keyboard Shortcut (Ctrl + k) to run this it runs again and again, and don't select the right worksheet.

Please check-out below updated attached.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you mohd9876!

Yeah! I tried with your method and works fine, but I don't know why the Cancel button doesn't work; codes surprisingly run after clicking on 'Cancel' button.

I have made a new UserForm...and the same as above I tried with a TextBox, which shows the active worksheet name to run the codes on that (Keyboard Shortcut: Ctrl + m). It work fine when I click on Enter button, but doesn't stop on clicking Exit button.


Please see my updated workbook of the same and help me out.

Thanks a world Mr. mohd9876!!

I just tried ur awesome tricks with another module (with ListBox method), and working fine ...WOW!!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Quick and Awesome Trick!! Thank you so much!!