ITraining Stats, upload version.xlsm
I have this macro which should insert data from the Calculator sheet to the appropriate sheet based off of whatever sheet name is selected from the drop down menu at cell Z18 of the Calculator sheet. However, selecting any sheet name from the drop down menu fails to make the macro run. What am I doing wrong?
Please Login or Register to view this content.
The code is OK but you aren't doing anything that will run it. You need to add the following code to the Calculator module:
I also highly recommend making this code change in Module15.exporttoexercisesheets, although the code will technically work without it:Please Login or Register to view this content.
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I looked at some other code. You have a bunch of empty Modules that should be removed to clean up. You also have code in Modules like this:
Please Login or Register to view this content.
but that code will only be effective if it is in a worksheet module, as I showed above. It will not be triggered in a Module.
It works, thank you very much!
You're welcome! Thanks for the rep, and thanks for marking your thread Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks