Can Clip Art be an Object??

[rudy]

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.

 

[Guest]

Basic principles here:

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

 

[rudy]

Thanks for the information

 

[rudy]

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.