Nostalgia80
New Member
- Joined
- May 20, 2013
- Messages
- 1
I have a spreadsheet that lists product data. Each row item (individual product) lists a unique ID. At the end of each row item, I have used a hyperlink formula to create a url....
EX: =HYPERLINK("http://www.example.com/product.aspx?ID="&F3&"&target=ts2", ""&A3&"")
In the formula above, F3 is the unique ID, and A3 is the name of the product
Next to this hyperlink formula cell, I have inserted an image....in this case, an image that looks like a 'Buy Now' or 'Add to Cart' button graphic.
What I would like to do is connect the URL generated from the 'hyperlink formula' to the button image. Is this possible? I have around 300 or so products, so I would like to do this in the quickest way possible. I have no experience with VBA.
Thank you for any help you can offer!
EX: =HYPERLINK("http://www.example.com/product.aspx?ID="&F3&"&target=ts2", ""&A3&"")
In the formula above, F3 is the unique ID, and A3 is the name of the product
Next to this hyperlink formula cell, I have inserted an image....in this case, an image that looks like a 'Buy Now' or 'Add to Cart' button graphic.
What I would like to do is connect the URL generated from the 'hyperlink formula' to the button image. Is this possible? I have around 300 or so products, so I would like to do this in the quickest way possible. I have no experience with VBA.
Thank you for any help you can offer!
