I have a dynamic report where I want to use Clip Art for the report
header. Based on a list box selection I want to display different Clip
Art report titles, i.e. if the User selects vendor then I want to
display the Vendor clip art object, if they select Color I want to
display the Color clip art object, etc....
I have all the clip art objects created and I want to only make the
correct object display based on the user selection. Does anyone know
if/how this can be done.

Thanks.


--
rudy
------------------------------------------------------------------------
rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911
View this thread: http://www.excelforum.com/showthread...hreadid=546751

Basic principles he

http://www.mcgimpsey.com/excel/lookuppics.html

--
Regards,
Tom Ogilvy


"rudy" wrote:


I have a dynamic report where I want to use Clip Art for the report
header. Based on a list box selection I want to display different Clip
Art report titles, i.e. if the User selects vendor then I want to
display the Vendor clip art object, if they select Color I want to
display the Color clip art object, etc....
I have all the clip art objects created and I want to only make the
correct object display based on the user selection. Does anyone know
if/how this can be done.

Thanks.


--
rudy
------------------------------------------------------------------------
rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911
View this thread: http://www.excelforum.com/showthread...hreadid=546751

Thanks for the information

--
rud
-----------------------------------------------------------------------
rudy's Profile: http://www.excelforum.com/member.php...fo&userid=3391
View this thread: http://www.excelforum.com/showthread.php?threadid=54675

Tom,

Thanks for the info... The link you gave is very logical but it does
not explain how to name a piece of clip art or a picture. In my
instance I highlight the clip art and define the name. When I
reference the name in the module it gives me the Method 'Range' of
object'_Global' failed error.

Thanks.


--
rudy
------------------------------------------------------------------------
rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911
View this thread: http://www.excelforum.com/showthread...hreadid=546751