VBA Variable

Mar 14th, 2002, 09:59 AM

I have written some macros to setup a page and print different sheets of the workbook based on pushing buttons. I also have radio buttons to select which printer that the user is printing to (some do not have 11x17 capabilities, etc). Based on the radio button selection, I want to set paper size to different values. It all works fine on the cover sheet where the buttons are, but how do I transfer that value from the radio buttons to the modules where the printing macro is written?

Mar 14th, 2002, 02:19 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 09:59 AM	#1
Guest Posts: n/a	I have written some macros to setup a page and print different sheets of the workbook based on pushing buttons. I also have radio buttons to select which printer that the user is printing to (some do not have 11x17 capabilities, etc). Based on the radio button selection, I want to set paper size to different values. It all works fine on the cover sheet where the buttons are, but how do I transfer that value from the radio buttons to the modules where the printing macro is written?