Using A Picture Link In A Comment To Make It More Dynamic!

Jan 19, 2010

It mentioned something about getting comments which display dynamic data as if something metioned in the cells will appear in the comment and on changing the data in the cells, the data in the comments also changes with it..

Unfortunately, I could not save that file or remember the website as my Internet went bonkers...

So can someone please help me with the same....

View 8 Replies


Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Nov 18, 2007

I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice

View 6 Replies View Related

Add Picture To Cell Comment

May 15, 2008

i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Ideally like what happens with the comments where you hover over the cell and the comment would pop up. or failing that may be a cell linking to the image.

View 8 Replies View Related

Inserting Picture Via Comment Box

Feb 24, 2012

I have this code tat I am using to important a picture via a comment box:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AI$10" Then
newpic = "J:help" & Range("AQ21").Value
Target.Comment.Shape.Fill.UserPicture newpic
End If
End Sub

The problem is if you put a value in AI10 that is not AQ21 it gives and error. I would like for it to call another cell (B3) for newpic in the case of a value that is not present in AI10.

View 9 Replies View Related

Add Picture To Cell Comment

May 15, 2008

i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Idealy like what happens with the comments where you hover over the cell and the comment would pop up. or failing that mabe a cell linking to the image.

View 6 Replies View Related

Copying A Picture From Cell Comment?

Mar 11, 2013

I'm trying to do something with pictures that have been inserted into cell comments. I'd like to be able to copy a picture that had been inserted into a cell comment, and save as .jpg with file name and file location designated by other cells in the spreadsheet. For example A1 contains "monkey" and has a picture of a monkey inserted into a comment on the same cell. B1 contains "zoo". I'd like to copy the picture from A1's comment and save as monkey.jpg to location c:zoo. Is this kind of thing possible in VBA?

View 5 Replies View Related

Comment Picture With List Data Validation

Jul 26, 2014

My goal is to have a picture pop up (preferably for a set amount of time), when a user selects a certain option from a data validation drop down list.

I have seen that you can add a picture to a comment, bu I can't combine comments with data validation lists.

Is there any way to get a comment to be part of a data validation list?

View 4 Replies View Related

How To Link Contents Of Cell To Comment

Jan 19, 2013

if its possible to link contents of a cell to a comment.

IE - Whatever the cell contents in sheet 1 A5 would reflect in the comment in sheet 2 A5 Im happy if its coded that would work.

View 4 Replies View Related

Link Picture To Dropdown Box?

Aug 8, 2014

I am trying to associate pictures to a dropdown box. The pictures are on a separate sheet. The picture is to be displayed on E20 and the drop down box is in K20. Im not very good at VBA and I accomplished this once before using the =INDIRECT function. But for some reason it is not working now.

View 1 Replies View Related

Change Picture Link

Aug 1, 2008

I have fond a couple of posts to achieve this however they all require selecting the picture first. Is there a way to change the picture formula without selecting the picture?

View 8 Replies View Related

Link A Picture To That Specific Product

Aug 29, 2007

I have excel worksheet with 2 sheets in it. Let’s call the one "Database", it consist of 713 rows and 15 columns with data in of my product. Then the other one "Display Product" in it you type in the code of the specific product so it search for my code and display all of the information of that product code on the "Display Product" sheet and it that work.

Now I want to link a picture to that specific product to the code. Here's the code I used:

Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A71")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With

End Sub

Now this code works fine up to a specific limit in my case 66 picture to a product, and I need at least 200 more images in it but I get a runtime error in my macro when I put one more image in. This is where I get the run time error -> “Me.Pictures.Visible = False“.
I don't know if excel is limited to image usage. Or maybe there is another way to do what I want to do with more advance coding.

View 12 Replies View Related

Link Cell To Picture Or Shape

Oct 18, 2007

It's difficult to explain, the attached shows the situation better. Basically there's a picture that is somehow linked to a cell. But, you can update the picture or the cell and the other one gets updated.

View 2 Replies View Related

How To Name A Dynamic Range & Make A Validation List (of 2 Dynamic Ranges)

Dec 22, 2009

I have a range which will change in size & in content, & I want this to be a Named Range at whatever size it is.

Reason I want to is because I want to make a Validation List with this dynamic range. I also want a Validation list which lists the content of 2 or more dynamic ranges which may or may not be on the same worksheet - is this possible?

First dynamic range: called "Milestones" at A11
Second dynamic range: called "Activities" at A25
& make a Validation list that will list content of both

View 9 Replies View Related

Excel 2007 :: Display Picture From A Link

Dec 9, 2011

I got a database that include a link for pictures stored in my drive.

I would like, to scroll trough the database entry and have the pictures resisze and displayed in a define region of my sheet.

How do I display a picture from a link?
How do I re-size so it fit in the region?
Working with Database

I'm using Excel 2007. I don't see anymore the form creation tool that I have used many many years ago.

View 2 Replies View Related

Excel 2010 :: Insert Picture Without A Link

Feb 5, 2013

I'm using a macro to insert a photo in to a Excel 2010 workbook. If the photo moves location it will no longer display the photo in the document as I belive the photo is being referenced instead of embedded.

If you then use the "Change Picture" icon the photo embeds but how do I get my macro to embed the photo.

Sub InsertPhoto(PictNo)

Dim SH As Worksheet
Dim Rng As Range
Dim MyPic As Picture
Dim sPath As String
Dim PicH As Single

[Code] ......

View 1 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Change Comment Box Shape And Make It Default

Jul 1, 2013

i changed the shape of "Comment" box with edit shape. However when i right click the updated shape and click on Set Autoshape Default it does nothing. When I insert a new comment it is back to old shape.

View 2 Replies View Related

Looking For A Cell To Make A Picture Pop-up?

Jan 17, 2014

Is it possible to have an "If this cell equals this amount, then make a picture appear" scenario?

Say there's a blank sheet, but if cell A1 is 1, then there will be a picture (or shape) in the center of the sheet.

View 2 Replies View Related

Macro To Make Insert Comment Window Appear Automatically

Sep 11, 2007

I have created an attendance tracker for a team of people at work. It simply involves a grid of the days of the month and on each 'day' (or cell) I have set up the Validation command to prompt the the user to select whether they were at work, on holiday, off sick etc. etc from a drop down box. If they do not change the cell, its defaulted value is that they are in work.

When a user selects the days that they are planning a holiday in the future, they are meant to write a comment on the cells they have changed, to advise when they had 'requested' the holiday.

What I would like is (a macro?) which makes the comment box automatically 'pop up' when they change a cell from its default value prompting them to fill in the details rather than relying on them to 'add comments' manually.

In addition, what would be the best way to 'restrict' them from booking holiday within the next 7 days - we have a problem with people booking holiday on '' for 2 days time, booking off the holiday on the spreadsheet and saying that they had it planned for weeks!

View 9 Replies View Related

Make A Drop Down List Show The Picture

Jan 2, 2007

I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).

Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?

The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.

View 14 Replies View Related

Make Same As Link

May 3, 2007

how cam I make same as link? zip.html. to install my own add-ins like that...

View 5 Replies View Related

Worksheet_Change To Make Two-way Link

Jun 3, 2006

I am trying to give the user the ability to hard a enter a value in either of two cells and then the other cell automatically changes to the same value when either cell is changed. If cell A1 on Sheet1 is changed to 20, want cell A1 on Sheet2 to also change to 20. But I also want the opposite to happen, if If cell A1 on Sheet2 is changed to 20, want cell A1 on Sheet1 to change to 20. I put this code on the Sheet1 module, but it doesn't work.

Private Sub Worksheet__Change(ByVal Target As Excel.Range)
Dim rWatchrange As Excel.Range
Set rWatchrange = ThisWorkbook. Sheets("Sheet1").Range("A1")
If Not Application.Intersect(Target, rWatchrange) Is Nothing Then
ThisWorkbook.Sheets("Sheet2").Range("A1").Value = ThisWorkbook.Sheets("Sheet1").Range("A1").Value
End If
End Sub

View 3 Replies View Related

Make An Email Link Go Away

Jul 16, 2006

I was using speech recognition to enter data into cells. It misunderstood me in several cells and placed an @ symbol at the end of the data. Now if you click up on that cell it tries to send an email. How do I make this link go away? everytime I type data into the cells, they are blue and underlined and create this email link.

View 3 Replies View Related

Create Excel Shape From MapInfo *OR* Make Picture Background Transparent?

Aug 13, 2008

I'm trying to make a map of 14 regions where each region changes brightness depending on values in the worksheets. I think I've got this bit sorted. I'm planning on creating the map using a collection of tessellated shapes or images, and using VBA to alter the properties of each one to create a dynamic map.

The output of the individual maps from MapInfo, our GIS software, is in .png or .jpg. format, and come with a white background. Is there any way to either make the background transparent so multiple shapes can be tessellated effectively, or a way to crop the image to the area's border?

Either that, or does someone know a way to output from MapInfo in such a way to make this possible? (Granted, it's a long shot, but you can't blame a guy for trying...)

View 9 Replies View Related

Dynamic Link Between Table And Chart

Dec 29, 2006

I m trying to make an Excel Charts that would update according to the choice made in a control box. I have uploaded the example test.xls. If you open the file, you ll see the graph is link to product 1. What I d like to do is if I choose product 2,3 or 4 from the control box, the chart updates itself to the good corresponding product.

View 2 Replies View Related

Make A Lookup On A String Of Words From One Of My Worksheets And Hyper Link

Oct 9, 2008

I want to make a lookup on a string of words from one of my worksheets and I also whant to make a hyper link so that when I click on the lookup command I should pop to the other worksheet were my database is.

View 2 Replies View Related

Link Two Dynamic Workbooks With Multiple Tabs

Nov 23, 2008

There are two teams in my department, and each is assigned to maintain their respective work book and I'm looking to link them in order to save some time.

Team A - Responsible for receiving Invoices (Bills) and entering them in an excel spreadsheet when received and update when bill is paid. Only one tab in this workbook.

Row A - Name of company billing us
Row B - Invoice #
Row C - Invoice Amount
Row D - Once Bill is paid the check amount is entered here
Row E - Balance Due (Row C - Row D = Row E)

Team B - Is Responsible for maintaining a list of all checks issued. All of the checks issued to pay the bills received by Team A are entered here plus other checks to pay a variety of different stuff. On this workbook a new tab is created every month. One tab per month. Since we need to follow accounting rules and record the check NOT on the month it was paid, but on the month the service was provided. for example I might be paying a bill in the month of November for services that were provided in September, so I would need to enter this check in the September Tab.

Row A - Name of company check is paid to
Row B - Invoice #
Row C - Amount Requested to be paid
Row D - Reason for payment
Row E - Date of check issued
Row F - Amount paid
Row G - Check #

Here is what I want to do.

I want to link both of these workbooks so that when Team B fills out the information of the check issued this will automatically update the Workbook of Team A so that
the balance is zeroed out.

He is my challenge. Workbook of Team B has multiple tabs so I can't just do a simple Vlookup and also every month a new tab is created (very dynamic workbook).

TO add to this in Team B's worksheets have to be in alphabetical order, which means that rows are inserted everyday. for example if I paid yesterday to A and C, I enter company A in Row1 and Company C in row 2 but today I received invoice from Company B so in order for them to be alphabetically I would need to insert a row between Row1 and Row2. So if I had links to this workbook they wold not update when the new row is added.

View 14 Replies View Related

Link Dynamic Named Range To Another Sheet

Apr 9, 2008

I have a dynamic named range named ’db’ in sheet1. I need to have the same range linked to sheet2 starting in cell A1.

View 3 Replies View Related

External Workbook Link With Dynamic Cell Reference

Feb 24, 2014

I currently have a file that is linked to an external workbook that is referencing a certain cell from a certain tab. The below is what Column A & B look like right now. What I'm wanting to know is is there a way to have the formula in Column B automatically reference the name in Column A (which is the tab name in the external workbook) instead of having to manually change the formula when the value in Column A changes?

In other words, I want everything in the external reference formula to remain the same except have the person's name change dynamically...

='X:Anderson CorporationEmployees[Work Hours]Mary'!$F$42

='X:Anderson CorporationEmployees[Work Hours]Joe'!$F$42

='X:Anderson CorporationEmployees[Work Hours]Frank'!$F$42

='X:Anderson CorporationEmployees[Work Hours]Michelle'!$F$42

='X:Anderson CorporationEmployees[Work Hours]Sam'!$F$42

View 1 Replies View Related

VBA - How To Make Range Dynamic In VLookup

Sep 30, 2013

I have this code which looks information in a table. The problem is that the table is getting every time bigger.

Here the code:


With Worksheets("Sheet10").Cells(9, 3).Resize(, LastColumnf - 2)
.Formula = "=IFERROR(CONCATENATE(VLOOKUP(Sheet10!C2,Sheet12!$A$10:$C$550,3,FALSE),""."",
.Value = .Value
End With

How can I write $A$10:LastNewRow... Another problem rises here, LastNewRow might end up being the oldLastNewRow, i think. But maybe since it is getting bigger, there is no problem, I don't know.

Instead of having a static reference like $C$550 I would like to have a dynamic one.

View 3 Replies View Related

Copyrights 2005-15, All rights reserved