Assign a value to an image/Referencing an image's alt text

[Dissonant]

I'm relatively new to excel programming.

What I want to do:

Assign a value to an image that will populate a value within the same row.

http://farm5.static.flickr.com/4046/...9804577d59.jpg

There's a link to a brief image of a part of my file.

As you can see I have 5 columns (Paid, Trade, Customer Extra, Not Paid, Self Promotion). Right now I am manually entering in "1's" in each of those columns to correspond to the image shown on the left.

Is there a way to assign a value to each image or create a macro so that it will manually populate the proper column? I'm thinking the easiest solution could be to create a macro that would populate the cell that the image is pasted into with the image's alt text. Fom there it's an easy matter of populating the proper column with "1's" Although I'm not really sure where to start with something like that.

 

[SamTYler]

It's possible, but every time a billboard changes customers, or a customer changes location or images, you'll have to rewrite the code.

I would key everything of the locations, because the locations in inventory will very rarely change. With Location in Col A and Customer in Col B and customer "LastPaymentDate" in another sheet keyed on Customer, a simple VLookup can tell you Date Paid, and Days Past due, and Overdue 15 Days, and Overdue 30 Days, etc, all in one column. Add a little Conditional Formatting and you've got a real report.

I would also keep the pictures out of the Workbook, because they really add to it's size in a hurry.

 

[Dissonant]

That's the real issue. The pictures need to stay. If it was purely text based it'd be a breeze to do what I want. What I really need is a way to access an images alt text and return it to a cell in the same row.

 

[Dissonant]

You're right, the locations rarely change but customers are moved to new locations on atleast a 30 day basis.

Just FYI. I've got a thread going on another forum:

http://www.excelforum.com/excel-programming/725500-assign-a-value-to-an-image.html

I'd prefer to not involve billing issues in the sheet beyond whether or not they're a paid/trade customer or if it's unpaid advertising. The other thread has a link to the base worksheet.

 

[SamTYler]

How about using the comment object in the cell under the picture? That can be read and wrote to without too much trouble.

 

[Dissonant]

The only issue with that is when the images are being moved, it's just the image and not the whole cell.

 

[SamTYler]

looks like you've got an answer in the other forum.