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....
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 Relatedi 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 RelatedI 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.
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 RelatedI'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 RelatedMy 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?
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.
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 RelatedI 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 RelatedI 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.
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 RelatedI 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?
i.e.
First dynamic range: called "Milestones" at A11
Second dynamic range: called "Activities" at A25
& make a Validation list that will list content of both
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.
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] ......
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 Relatedi 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 RelatedIs 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.
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 'lastminute.com' for 2 days time, booking off the holiday on the spreadsheet and saying that they had it planned for weeks!
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.
how cam I make same as link? http://rapidshare.com/files/29223104/JR_DatePicker_v1. zip.html. to install my own add-ins like that...
View 5 Replies View RelatedI 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
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 RelatedI'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...)
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 RelatedI 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 RelatedThere 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.
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 RelatedI 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...
Mary
='X:Anderson CorporationEmployees[Work Hours]Mary'!$F$42
Joe
='X:Anderson CorporationEmployees[Work Hours]Joe'!$F$42
Frank
='X:Anderson CorporationEmployees[Work Hours]Frank'!$F$42
Michelle
='X:Anderson CorporationEmployees[Work Hours]Michelle'!$F$42
Sam
='X:Anderson CorporationEmployees[Work Hours]Sam'!$F$42
I have this code which looks information in a table. The problem is that the table is getting every time bigger.
Here the code:
VB:
With Worksheets("Sheet10").Cells(9, 3).Resize(, LastColumnf - 2)
.Formula = "=IFERROR(CONCATENATE(VLOOKUP(Sheet10!C2,Sheet12!$A$10:$C$550,3,FALSE),""."",
VLOOKUP(Sheet10!C2,Sheet12!$A$10:$C$550,2,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.