How do you name a picture with a value?

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

In a piece of advice given to me earlier, someone suggested that:

"...if the entry in the drop-down list is 'Mercury Inc', then name th
picture with that same value."

Can anyone tell me how do I do this? I'm using a Data Validation lis
to shift pictures from one place in a workbook to another using VB cod
given to me by the same guy. I need to know within the next hour o
two.

thanks a bunch!!

(If you're reading this Bob, the reason I'm asking the forum and no
you it's because I left the workbook you sent me at work, and i need t
finish something tonight).

a
 
Highlight the image you want to rename..........then in the Name Box, just
above column A, you'll see the name of that image, probably something like
"Picture 2".........then just highlight and overtype that name.......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top