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:
Last edited by SunOffice; 09-05-2011 at 09:11 AM.
Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!
Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module
the problem is in your submit button you are calling the same macro that shows the userform that is why it runs infinitely; so your code for submit button should be like this:
Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module
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.
Bookmarks