rcross23
03-22-2012, 11:07 AM
Hey guys,
I'm trying to create a macro so that whenever i hit the keys assigned to the macro, it will bring up a serious of pop-up input boxes, so that i can enter data (both numeric and text) and then have it create a pre-defined formula using the information that was entered into the boxes.
For instance, one formula i would like to make a macro for would be =cw_act("X","Y->Z"), where X, Y, and Z would be populated by the input boxes.
Even better would be if the pop-up box would have a pre-populated list of formula options and then depending on which one i select (by number) it would dictate which pop-up boxes I am given and therefore which formula is created.
Any help would be greatly appreciated! Thanks!
I'm trying to create a macro so that whenever i hit the keys assigned to the macro, it will bring up a serious of pop-up input boxes, so that i can enter data (both numeric and text) and then have it create a pre-defined formula using the information that was entered into the boxes.
For instance, one formula i would like to make a macro for would be =cw_act("X","Y->Z"), where X, Y, and Z would be populated by the input boxes.
Even better would be if the pop-up box would have a pre-populated list of formula options and then depending on which one i select (by number) it would dictate which pop-up boxes I am given and therefore which formula is created.
Any help would be greatly appreciated! Thanks!