Excel 2007 :: Picture Created With Unique Names - Adding Comments To Cell

Oct 23, 2012

Excel 2007

I have a few dozen pictures created when a macro runs. They all have unique names. I'd like to add comments to cells, where the cell.value decides which picture to pull. All the examples I've found online show how to do this if you have pictures saved on your hard drive by referencing the file path "c://mydocs/...blahblah/"

Is there a way to reference the pictures I've created/named with my macro?

Here's the snippet of code that creates the pictures and names them:

Code:
For i = 2 To Application.CountA(Sheets("Allocation").Rows(1))
Sheets("Allocation").Activate
Set rInput = Sheets("Allocation").Range(Cells(1, i), Cells(10, i))
sPicName = "_" & Sheets("Allocation").Cells(1, i) & "_"
sSheet = Sheets("Allocation").Cells(3, i)
dDate = Sheets("Allocation").Cells(5, i)

[Code] ......

Here are some examples that are close to what I'm looking for.

VBA Popup Pictures - 1108 - Learn Excel from MrExcel Podcast - YouTube
VBA Express : Excel - Add pictures that float like comments.

View 4 Replies


ADVERTISEMENT

Excel 2007 :: Edit Links And Still Retain Cell Comments?

Jan 17, 2014

How can i break the links in a row of cells but still retian the cell comments thereafter.

At the moment, the comments dissapear after editing the links in excel 2007 that i am using.

Changing the display (foe cells with comments, show) under file-options-advanced has not really worked.

View 1 Replies View Related

Excel 2007 :: Cutting Portion Of Cell Value To Cell Comments

Aug 9, 2012

I have an Excel 2007 workbook with several sheets, and various cells in several of the sheets have column headers with a description in the same cell enclosed in curly brackets, e.g. Header{Description}. I would like to to keep the column headers in their respective cells, but move (cut) the descriptions along with the brackets to the respective cell comments.

View 1 Replies View Related

Excel 2007 :: Change Username In Mouseover Status Bar Message For Cell Comments?

May 30, 2012

I am having with Excel 2007.

When I hover the mouse over a cell with comments, the status bar displays a message; for example "Cell A12 commented by A satisfied Microsoft Office user".

I only get this message for one column. The cells in all other columns give my first and second name as the author of the cell comment.

Why it is only effecting one column. I have been unable to change the annoying "commented by A satisfied Microsoft Office user" to my own name.

Is there a macro that can do this? I tried two macros I found online, both from a few years back, but neither of them worked.

View 2 Replies View Related

Adding Values Against Unique Names

Apr 2, 2009

I have a spreadsheet with a series of names in a column and respective dollar values in a separate column. I would like a formula to automatically total the value spent against a particular name (without having to enter the name as a value each time).

Example

John Doe 3.89
John Doe 1.27
John Doe 0.98
Amy Smith 1.56
Amy Smith 2.29
Amy Smith 1.11
Alex Brown 0.67
Alex Brown 4.56
Alex Brown 8.87

I would like a formula to automatically populate a column, spreasheet, etc as follows:

John Doe 6.14
Amith Smith 4.96
Alex Brown 14.10

View 4 Replies View Related

Excel 2007 :: Chart Created Using Name Ranges

Jan 28, 2013

I have built a chart using dynamic nameranges. The problem that I am facing is I tested it on two systems . One system the charts works fine but the other system the charts does not work . Both are excel 2007. Now the error that I get is if I see the chart data source from one system it is showing "!". The other file shows the chart data source as "0!". What should I be checking so that it works in the other system as well?

View 6 Replies View Related

Excel 2007 :: Adding Date Last Modified In A Cell Using VBA?

Jul 10, 2012

I need to insert a date modified column to an Excel 2007 workbook I am currently using. The columns range is from A to L, with about a hundred data points. However, I would like to have the date modified cell update only when there are changes to rows F through L, starting with row 3.

I need the code to still function if I add rows, and it would be great if it would also still run if I added columns, but that part is not necessary. I've gotten close by defining a cell name as myCol and using this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Row < 3 Then Exit Sub

[Code].....

View 4 Replies View Related

Excel 2007 :: Adding Characters In A Cell With Various Fonts

Jun 18, 2013

My group is putting "marks" in Excel (2007) work papers & sometimes they may want to add additional marks to those previously added in a selected cell. What I have below actually works, but I just got my VBA book last week & there has to be a better way.

Specifically, I've saved the "target" off in the same worksheet (That can't be good.) and delete it when I'm done writing it back. Can I save the original characters virtually, or to the personal.xlsb.

Code:
Sub addMarkInCELL()
'
Dim charCount As Integer
Dim charStart As Integer
Dim rngTarget As String
charCount = ActiveCell.Characters.Count

[Code] ..........

View 2 Replies View Related

Excel 2007 :: SUM Numbers Within Cell Based On Unique Strings In Another Cell?

Jan 11, 2012

how would you do the following in excel 2007:

"SUM numbers within a cell based on unique strings in another cell".

For example, how would i use formula to SUM the following numbers (and only the numbers for david and sam only once), 700+454+50+40+2+129+16

700david
700 david
454john
50buch
40daniel
2sam
2sam
129mike
16steve

View 9 Replies View Related

Excel 2007 :: Adding Feedback Message Based On Cell Value?

Jan 9, 2012

Using Excel from Office 2007, and WinXP Pro OS

I have a spreadsheet which contains 2 drop down pick lists in Field1 and Field2.

Code:
FIELD1 | FIELD2 | FIELD3
--------------------------------------------
In Cell A2, I have this set in Data > Data Validation:

Allow: List
Source: =CatList

If the user selects a value from the CatList range, then the drop-down options in Field2 are updated accordingly.

In Cell B2, I have this set in Data > Data Validation:

Allow: List
Source: =INDIRECT(A2)

The Ranges are as follows:

Code:
Cat1 | Cat2 | Cat3
---------------------------------------------
Cheese | Hat | Square
Trees | Cat | Circle
Bees | Sat | Triangle
Knees | Mat | Rectangle
Apologies | Bat | Octagon

I'd really like to be able to add a message into FIELD3, which is based on the value in Cat2

e.g. using pseudocode, something like:

If Field2 value = "Apologies" then put this message in Field3: "This requires approval from A"
elseif Field2 value = "Triangle" then put this message in Field3: "This requires approval from XYZ"
elseif Feidl2 value = "Bat" then put this message in Field3: "This does not require approval"

Basically this is for an access form, and I need to be able to add a feedback message to field3 based on what's in Field2.

I thought about using the INDIRECT option to add messages but I can't see how I'd do it. Maybe VB would do it, but I don't know it well enough.

View 3 Replies View Related

Excel 2007 :: Changing Picture In Heading Bar

Mar 7, 2013

I am having a problem updating a jpg file in an existing Excel file which I created. There is a LOGO in the right hand side Header block which I can delete ( the words &(Picture) appear after the logo is deleted. For some reaon I cannot replace this LOGO with a newer version. The new LOGO appears in the body text area, bot it will not drag into the header. I must have missed something very basic!!

View 4 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

Can Create Data Validation List Of Names Created In Name Box Or Sheet Tab Names

May 7, 2012

Can I create data validation list of the names created in the name box or of the sheet tab names?

View 5 Replies View Related

Excel 2007 :: Conditional Formatting And Adding Text To Cell Based On Multiple Cells

May 31, 2013

I'm using Excel 2007. I would prefer to stay away from the scripting side of the house if possible. This is basically a 3 day forcast weather chart. The top is the actual weather data, the bottom portion is a color coded reflection of how the weather affects various things.

This product is created in excel, but will be embedded into a powerpoint. It will be updated daily. Here is what I would like. I want the color chart at the bottom to update automatically based on the data I enter above. I have a grasp that I can update the color through conditional formatting, although im not exactly sure what that will look like with all of those cells.

I also figured out that I can insert the letters in those lower cells with something similar to " =IF(C6>90, "T", "") " which would put in a 'T' for Temperature when the temperature got above a certain degree.

I run into a problem when I have multiple factors affecting a single cell. For instance on the example in day 2 of my image. Personnel are affected by Temperate AND UV Index. How would I set up that cell to pull that information from both of those cells and display it accordingly? I would prefer the letters to stay separated by the comma, but I could live without that. The default cell color will be green, with the potential to be yellow or red. I left a few examples of possible situations on day 2 and 3.

View 3 Replies View Related

Excel 2007 :: VBA Code To Resize Picture In PowerPoint

Feb 14, 2012

So far my VBA will copy my range of cells in Excel and paste them into Powerpoint but I'm totally stuck as to how to resize the image from there. I've tried a bunch of different methods and I get some pretty crazy results but can't seem to punch through to a solution. What I'd like it to do, at the end of the VBA is:

Set the lock aspect ratio to false
Set the Height to 5.5"
Set the Width to 9.83"
Set the horizontal position to .08 from Top Left
Set the Vertical position to .58 from Top Left

I cannot seem to get my save as portion to work at all. I commented it out at the bottom. This is all in Excel and PPT 2007.

Here is what I have so far:

Sub Export_Excel_to_PowerPoint()

Dim ppApp As PowerPoint.Application
Dim ppSlide As PowerPoint.Slide
On Error Resume Next
Set ppApp = GetObject(, "PowerPoint.Application")
On Error GoTo 0

[Code]...

Ultimately the behavior I'm looking for with this macro is to copy a filtered range of cells from Excel and paste it as a picture into Powerpoint (up til this point I'm golden) then resize the image on the slide, save the presentation, then exit PPT.

View 1 Replies View Related

Excel 2007 :: Create Macro To Copy Chart As Picture

Sep 1, 2012

Trying to create a macro to run through the following steps when I select a chart and run the macro:

Paste>As Picture>Copy As Picture>As Shown When Printed>OK

I used the macro record feature and when I enter the shortcut it always returns the same chart. How do I get it to run on whatever chart I have selected instead?

I am constantly using this function to copy charts from Excel into PowerPoint presentations and am frustrated with all the extra steps it takes (versus just Ctrl-C).

View 9 Replies View Related

Excel 2007 :: Pop Up Picture When Mouse Move To Object In Sheet

Nov 10, 2012

i am totally new in excel and i am using excel 2007, my question is : how can i create an object in an excel sheet, so that when the mouse cursor move to it, it pops up anohter image?

View 4 Replies View Related

Excel 2007 :: Automatically Change The Worksheet Tab Names With Cell Value In Each Worksheet?

Feb 14, 2012

I am fairly new to macros and have trouble with VBA. I have a file with multiple worksheets. Each worksheet contains the name of a specific location in cell A8. I want this name in cell A8 to be the name on the worksheet tab for each worksheet in my file but do not know how to accomplish this. Is that even possible?

View 3 Replies View Related

Excel 2003 :: Put Picture Into A Cell And Get Picture Name From Another Cell

Mar 23, 2014

I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.

The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.

My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).

I've tried many macros but none work.

View 14 Replies View Related

Excel 2010 :: Linking Cells - Adding Names

Jan 14, 2013

I have an excel sheet (version 2010) that has a few sections that you can add in names (via drop down box). I also have a spot where i want these names to populate - on a second sheet.

Ex
Truck #1:
1. _____
2. _____
3. _____
4. _____
5.______

Truck #2:
1. _____
2. _____
3. _____
4. _____
5.______

Truck #3
1. _____
2. _____
3. _____
4. _____
5.______

Truck #4
1. _____
2. _____
3. _____
4. _____
5.______
6.______
7.______
8.______

My problem is when I refer to the first worksheet from the second worksheet it shows blanks where there are no names. For example i want the second sheet [ LOC ] to show the names that appear under Truck #1, #2, #3, #4 - but truck #1 may not always have names under it?

Sample Excel file attached - Help.xlsx‎

View 6 Replies View Related

Excel 2003 :: Adding Blank Line Between Company Names

Feb 6, 2013

I have a 97-2003 spreadsheet with approximately 22,000 lines of seperate companies. I need to know how to insert a blank line between the company names. I have been using the "Right Click - Insert" method but soon realized there must be 2000 different companies. The Company Name column is A.

View 7 Replies View Related

Excel 2007 :: Find All Names According To Data

Nov 21, 2012

I have a table with names of employees in Column A, the data for each employee is written in columns B, C and D.

I'd like to be able to type in this data in cells E12-E14 and have Excel bring up all of the names in the table that are associated with this data, and preferably separate them with commas.

I'm working with Excel 2007, without VBA/Marcros.

Please see the example file: find_name_example.xlsx

View 7 Replies View Related

Excel 2007 :: Counting Unique Values

Dec 9, 2013

I am using Excel 2007

I have 50 000+ rows that covers fiscal years from 2006 to 2014 and I want to calculate how many unique clients are there per asset type per fiscal year. In addition, the results table needs to adjust to filters i would use on the raw data..

As:

2007
2008
2008

Commodity
45
FX

Other
other

Here is a sample file: SampleData.xls

View 8 Replies View Related

Excel 2007 :: Count Of Unique Values

Nov 18, 2011

I would like to get the count of unique values in my 2nd column using my values in 1st column as the criteria. Below is my example of my data set.

EFGH5DeptHC

6A304794A17B86122B38B86179C39B90050D1310C82705

11C94955

12C308165

[Code] .........

Excel 2007

I would like to see the count on column H (highlighted in yellow).

View 1 Replies View Related

Excel 2007 :: New File From Unique Listings

Feb 22, 2012

I'm having some trouble with a spreadsheet copy.

I have a spreadsheet listed out with 2-3 pieces of data per row like:

Mark - abc
John - def
John - ghi
Abby - xyz

etc.

What I need to do is create a new file for each unique string in column A. So for my brief example above, the "Mark" file would have 1 row, the "John" file would have 2 rows, etc. I also need to save the new file by the name in the first column (so "mark.xls"). (Conveniently, the table is sorted by the first column already.)

What I did was create a new worksheet for each row and then save that as my file. However I'm having problems getting my file to contain more than one row (I can get either the first or last row, but not all of them). I have about 30 spreadsheets to do this for, and each will create 80+ files... I'd really rather not do them by hand.

I'm on Excel 2007 if that matters.

I cobbled together some code I found in various places and this is what I have so far:

Code:

Sub CreateWorkbooks()
Dim newSheet As Worksheet, regionSheet As Worksheet, CurSheet As Worksheet
Dim cell As Object
Dim regionRange As String
Dim lngRows As Long
Dim CurRow As Long

[Code]...

(note that the comments are what it is supposed to be doing, not necessarily what it is doing)

View 5 Replies View Related

Excel 2007 :: Extracting Unique Into Another Column

Feb 1, 2013

Column A has following names: A5 Peter A6 Sally A7 Andre A8 John A9 Wayne Column B has following names: A5 Andre A6 Wayne

I need Column C to show names that are in Column A but not in column B ...

Column C should show following: C5 Peter C6 Sally C7 John

I am struggling with this in excel 2007

View 1 Replies View Related

Excel 2007 :: VBA To Find Unique Rows

Jul 29, 2013

I am wanting to find rows that with unique values in the first column, and then take those rows and display them in a more readable format. The section titled input is an example of information that would be pulled from a query into Excel. The Desired Output section is how I would like the info to be displayed. If this is possible without VBA then that is even better.

Excel 2007
A
B
C
D

[Code].....

View 2 Replies View Related

Excel 2007 :: VBA Get Unique Values Set In Filter

Nov 29, 2013

[Excel 2007]. I'm trying to get the list of unique values from a Filter on a column in VBA.

I've given the column a Range Name

Code:
Dim rClient As Range
Set rClient = ws.Range("CLIENT_NAME")

Dim aClients() As Variant
aClients = rClient.???

There's nothing in the range method dropdown that obviously relates to the Filter on the range.

Is it something to do with the Table method?

View 2 Replies View Related

Excel 2007 :: Use Of Month Names In Entering Date Through VBA

Jun 26, 2013

In the workbook the sheet names are month names e.g. july,august,September etc and 1st of each month is to be entered in a cell in each the sheets. By some trial and error I wrote this macro

VB:
Sub test()
Dim j As Integer, monthnr As Long, monthname As String
For j = 1 To Worksheets.Count

[Code]....

This worked in July sheet it is written as 7/1/2013 and in august sheet it is 8/1/2013 etc Then I shortened the macro like thlis

VB:
Sub test()
Dim dte As Date
dte = "july" & "/1/2013"
Range("A1") = dte
End Sub

It worked. Even if I use shortened 3 letter form of month like "Jul" or "aug" then also it works

But if type on the spreadsheet itself
="july"/1/2013
It Gives value error.

Perhaps it works only in vba and not spreadsheet.

I accept nobody is going to use "july" & "/1/2013" instead of 7/1/2013 But this will be useful if sheet names are month names so that when we write the date we can use sheet names Mine excel 2007 and windows 7.

View 2 Replies View Related

Excel 2007 :: Sorting Names In Pivot Table

Jan 3, 2012

I have created a pivot table using a family name in row labels. The names appear in alphabetical order unless the person's name is the same as a month or day of the week. The result is that I have Mr Sun and Mr May at the top of my list, rather than listed alphabetically. Sorting the list does not solve the problem. It switches Mr Sun and Mr May, but does not included them in the main list. Is there a setting I can use that will stop Excel 2007 thinking that these words are something that they are not?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved