I need expert MS Excel help please

AlexGT · Nov 3, 2006

I am trying to do a small excel sheet and I need a function or macro that can display pictures from a list of hyperlinks or excel embeded images (gif,jpg) without having to manually click on the hyperlink.

Say on one cell I type http://www.edhelperclipart.com/clipart/time/Time1205.gif and a function or macro in another cell should automatically bring up the image the hyperlink refers to as an excel embedded object.

I consider myself very good at Excel, but can't figure that one out. Any ideas as to what function or macro should I use to achieve my goal?

Thanks!
AlexGT

StevieRay · Nov 3, 2006

Alex,

You can post your question to the message board at http://www.mrexcel.com

AlexGT · Nov 3, 2006

Thanks I'll post the question there

AlexGT

chrwe · Nov 4, 2006

Never done that, but it shouldn't be too hard:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim monitoredFields As Range
Set monitoredFields = Range("A1:A1")

If Intersect(Target, monitoredFields) Is Nothing Then
Exit Sub
Else
'put code to embed object here
End If

End Sub

I need expert MS Excel help please

AlexGT

Flashlight Enthusiast

StevieRay

Enlightened

AlexGT

Flashlight Enthusiast

chrwe

Newly Enlightened

Similar threads

Latest posts