Selecting Graphics

lmc_budd · May 13th, 2002, 02:49 AM

I need to select one of four graphic images, (all overlaid in the same space on the spreadsheet), depending on the value of a particular cell. E.g. if cell A1 contains the value 3, I need to bring the third graphic image to the front. Any ideas?

Tom Schreiner · May 13th, 2002, 03:24 AM

An idea.
I believe you will need VBA to do this...
What are the names of your graphics?
Select each one and note the name in the namebox above column A.
Tom

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

May 13th, 2002, 02:49 AM	#1
lmc_budd New Member Join Date: Apr 2002 Location: London, UK Posts: 34	I need to select one of four graphic images, (all overlaid in the same space on the spreadsheet), depending on the value of a particular cell. E.g. if cell A1 contains the value 3, I need to bring the third graphic image to the front. Any ideas?

May 13th, 2002, 03:24 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	An idea. I believe you will need VBA to do this... What are the names of your graphics? Select each one and note the name in the namebox above column A. Tom