MSGBOX/Radio Button to select logo

L

LB79

Not sure if this is possible.

I have a report template that is used for several different brands o
my company. When i use the template i want a MSGBOX to open up and lis
3 buttons - 1 for each brand. When a button/brand is selected it wil
choose the relevent logo and add it to the report.

If possible the logo will only appear on the print out and not on th
screen.

Can anyone help me with this of is there an alternitive?

Many thank
 
B

Bob Phillips

I have a technique (actually a combination of 2 techniques) that can pop up
a dialog, and copy an image in dependent on the selection.

But ... all images would need to be on the worksheet (off visible), and so
the print area would need setting, and it would show on screen. I this too
restrictive?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top