What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Excel 2003 Spreadsheet

I have a product drawing that’s saved as a jpg and will insert it into my spreadsheet. I want to be able to automatically update certain dimensions (e.g. length, width and height of product) based on values in my spreadsheet. What’s the best way to accomplish this?

I’ll have a form where the user specifies certain parameters of the product including length width and height and these values will be saved in my spreadsheet by customer. Depending on which customer is selected, I’d like to display dimensions on my product drawing image for that customer. I wanted to place text boxes with this data on my product drawing picture but Excel only allows text boxes on forms, right?

Keep in mind I'm not trying to change the height of the picture. The picture should stay fixed. I want to change the value of a dimension that's displayed on the picture. So if cell A1 has 31" for the height, I want to show the value 31" on my picture where the height dimension is shown (i.e. picture is in background & 31" value is in the foreground). This applies to the other dimension values as well.

Any insight would be appreciated.

-------------Problems Reply------------

I would just place a textbox on top of the picture, set the formula of the textbox to reference the cell and group the textbox and picture together to hold the textbox in place.

The following macro is an example

Sub Test2()
Dim P As Picture
Dim TB As TextBox
Set P = ActiveSheet.Pictures.Insert("C:\Temp\eg4.jpg")
Set TB = ActiveSheet.TextBoxes.Add(P.Left + 20, P.Top + 20, 40, 15)
TB.Interior.ColorIndex = 2
TB.Font.Size = 8
ActiveSheet.Range("A1") = "20cm"
TB.Formula = "='" & ActiveSheet.Name & "'!$A$1"
P.Select
TB.Select Replace:=False
Selection.Group
Range("A1").Select
End Sub

Thanks Bill, that's what I needed to know!

Jeff

Category:Office Views:9 Time:2012-04-03

Related post

  • How do I in Word 2003 update all fields except my embedded link to the Excel 2003 spreadsheet? 2012-09-06

    I'm working further into my original template (see this post here) and have noticed one "last" glitch (famous last words not withstanding): On page one of my "OrderForm" document and template, I have an Excel 2003 spreadsheet. On page 2 there is a li

  • Automatic Update for Windows Mail Junk E-mail Filter for x64-based Systems [November 2011] (KB905866) Installation status: Failed. 2012-01-25

    My Windows is set for automatic updates, I'm running Vista SP2. Update for Windows Mail Junk E-mail Filter for x64-based Systems [November 2011] (KB905866) has failed to load a number of times. It has given Error details: Code 800736B3. Downloaded an

  • Unintended file dialog when updating links in Excel 2003 VBA 2011-04-06

    I'm keeping sets of interrelated Excel 2003 spreadsheets for each of my company's projects. I want to copy some template XLS files to the project name and change the links that connect them to each other. For example, the file TEMPLATE_ScanProgress.x

  • I want my C# Windows Service to automatically update itself 2008-09-20

    Is there a framework that can be used to enable a C# Windows Service to automatically check for a newer version and upgrade itself? I can certainly write code to accomplish this, but I am looking for a framework that has already been implemented and

  • "Automatic updates" for Java (desktop) application? 2008-11-20

    What system do you recommend for implementing "automatic updates" for some java (desktop) application? I'd also want to have module/plugin installation and update. Think Eclipse and Firefox. I'm aware of Eclipse RCP's OSGi stuff, and also NetBeans RC

  • How do I turn off automatic updates in Aptana Studio for Eclipse? 2008-12-16

    I installed Aptana Studio plugins for Eclipse and now Eclipse startup is slower than ever because Aptana Studio always checks for updates at startup -- and it's really slow! How do I turn off auto updates in Aptana? --------------Solutions-----------

  • Automatically update AddedBy and EditedBy fields in SubSonic 2009-01-06

    I have a data model that includes common columns like addedBy, editedby (user), addedDate, editedDate. Is there a setting I can use in SubSonic 2.1 that will automatically update these fields appropriately instead of having to explicitly specify in e

  • Should a web app have automatic updates? 2009-02-17

    After seeing some of the problems that Microsoft has had upgrading people from Internet Explorer 6 and also seeing how Firefox has automatic updates, it's made me consider the benefits and drawbacks of a push-style upgrade system for our web app. In

  • Automatic updates - what is 'adequate' security? 2009-02-23

    There are a few questions (C#, Java) that cover how one might implement automatic updates. It appears initially easy to provide automatic updates, and there are seemingly no good reasons not to provide automatic updates for most software. However, no

  • automatically update my .NET application in Vista without admin rights 2009-04-16

    I know there have been a ton of questions about how to implement automatic updates in a .NET application, and I've probably read most of them. Unfortunately, none I have seen quite fit my situation as far as I can tell. I am trying to build a self-up

  • C# Databound ComboBox Automatic Update 2009-05-03

    I have a combobox bound to a database table. When the user inserts a new piece of data into the table, I want the combobox to be automatically updated to display this data, however I am unsure of how I would go about doing this. Help would be greatly

  • How do I offer automatic updates for my program in Visual Basic 2008? 2009-05-04

    How do I set up automatic updates for my program in Visual Basic 2008? I would like the user to be able install the program from a setup.exe file then run the auto update function within the program. How do I do this in Visual Basic 2008? -----------

  • Automatic updating of Xcode build phases for a target? 2009-05-20

    It seems that in a standard Xcode project, the default target automatically "updates" the Compile Sources build phase with any newly-added implementation files. This saves the user from having to drag each new file into the phase. I have defined a se

  • How to automatically update tag file in vim? 2009-07-21

    I use vim C++ tag file for navigation using Ctrl-]. The problem is whenever some file gets modified, the links are no longer valid and I have to re-run ctags and update the tag file. Our code base is huge and it takes quite a while for generating tag

  • .NET Deployment Options with Patch management / Automatic updates 2009-11-16

    What are the options available to deploy a .NET desktop application built using WPF other than ClickOnce? Top priorities are should work over the wire (internet or intranet) updates management; options to check for software updates and automatic upda

  • Out of browser Silverlight app - how to setup automatic updates? 2009-12-17

    I'm wondering how to setup my Silverlight project to enable automatic updates for out-of-browser application. I added some code in app.xaml.cs (see below), rebuild app, installed as out-of-browser, changed versionionfo in asseblyinfo.cs, rebuilded, r

  • Automatic update solutions for a Win32 application? 2010-01-07

    We've got a desktop product, made up of a Win32 service, a notification icon application and associated DLL files. I've been tasked to look at making it auto-update. We could write our own updater, but before we do that, I'd like to see what else is

  • Can I use subversion in such a way that "commit" automatically updates my server files? 2010-02-02

    I would like to know if there is any way to make it so that when I commit changes using Subversion, that the changes are automatically reflected on my server in the testing folder? Perhaps this idea is irrational. I'm struggling to get a good big-pic

  • How to automatically update TableAdapter bound to TextBox 2010-02-03

    I have a WPF Window with several TextBoxes on it. I have an XSD dataset attached to a SQL server database, and the window is bound to a row from the tableadapter: public partial class PersonForm : Window { public PersonForm(int id) { InitializeCompon

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.106 (s). 11 q(s)