Automate printing to accept user input options

[chasoe]

Dear Experts,

I would like the codes to allow user to choose between 2 printing options :
option "A" : to print in A3 and in single sheet
option "B" : to print in A4 and in 2 sheets

If user chooses "A", then the code shall call up a macro named "X"
If user chooses "B", then the code shall call up a macro named "Y"

Note that I have already on hand the coded macro "X" and "Y" to print in A3/A4 and 1/2 sheets.

It looks simple, but I just don't know the technique.

Grateful for your kind help in advance.

Thx & rgds,

Edward

[Kevin#]

There are a few ways you could do this. Here is one. See attached workbook and amend value in B1

In cell B1 create a data validation dropdown for OptionA and OptionB

PrintOptions.jpg

Then put a change event code into the sheet module - this code runs automatically when the value in cell B1 changes. It runs macro X or macro Y based on value in cell B1 and then returns B1 to default value "Select Option"

Insert this macro in the relevant sheet module

Please Login or Register  to view this content.

[chasoe]

Sorry for late reply, as I've been using my extremely limited vba knowledge to look for other possible ways in the internet other than your suggestion, by cutting and pasting code patches only as I cannot write vba from scratch.

Please Login or Register  to view this content.

I've finally completed it but do not know how to remove the "Confirm / Cancell" button in the message boxAttachment 457787. I wish to allow user to only click options from 1 to 5 as listed in the message box and no others. (clicking Confirm / Cancell will show error)

Appreciate further help.

Thx a lot.

[humdingaling]

change MyInput to String instead of integer

Please Login or Register  to view this content.

ps also
if you do not want 5 to do anything just don't include it as an case in your select instead of making it go thru select process and sub process for no reason

[chasoe]

Thank you. Everything Ok without error message now when clicking "Confirm / Cancell".

Thanks for all your help.