jistre
Mechanical
- Oct 1, 2003
- 1,147
I have a macro I wrote that I'd like to share. It's pretty nifty in that it pulls up dialogs that let you specify precisely where you want the view to be. It allows you to specify the angles between your viewpoint and the top and right planes. Then radio buttons allow you to specify whether you want to be above or below the top plane, in front of or behind the front plane, and whether you want to rotate CW or CCW about the Y axis. The large create button will position the view as specified and if that's not to your liking, you can change the variables and hit create again to change it until it's as you want. Then you can name the macro as you wish or keep the default. Finally, when everything's to your liking, you can hit the done button, and only then with the view actually be created and inserted into the view listing.
The problem is that the main routine of the macro simply calls up a user form and ends. The actual computations and manipulations are done from within the form, and while I can post that code easily, the information about the form's layout and naming conventions are lost, and the code is useless without that. I guess what I'm looking for is some way to post the binary. I know that brings with it all kinds of problems, but it can be reviewed for bugs/malicious code by both the moderators of the site and the people who download it.
I simply don't know enough VBA to create the form completely within the main code of the macro.
The problem is that the main routine of the macro simply calls up a user form and ends. The actual computations and manipulations are done from within the form, and while I can post that code easily, the information about the form's layout and naming conventions are lost, and the code is useless without that. I guess what I'm looking for is some way to post the binary. I know that brings with it all kinds of problems, but it can be reviewed for bugs/malicious code by both the moderators of the site and the people who download it.
I simply don't know enough VBA to create the form completely within the main code of the macro.