insert image

  1. H

    Insert image without link

    Hi, I use the following code which works as wanted: Private Sub CommandButton1_Click() Dim myPicture Dim MyObj As Object Application.ScreenUpdating = False Sheets("Kumkort").Unprotect myPicture = Application.GetOpenFilename _ ("Bilder (*.gif; *.jpg; *.jpeg; *.png; *.bmp; *.tif),*.gif...
  2. P

    Search all sheets in workbook for cell value and insert image

    I'm having trouble with my macro and I feel like I'm not seeing things clearly anymore, any help is helpful, especially with the idea of looping 1. Prompt user for folder (I have this done and I stored it as MyDir as a string) 2. Folder contains image files with names that are found in a cell...
  3. J

    VBA / MACRO for inserting picture based on the contents of a cell changes

    Hi Im wondering if anyone can help me with something. Im looking to insert a picture into my excel sheet based on the contents of an input cell. so when name in the input cell changes so does the logo/picture. any help would be much appreciated. Im currently using the Mr.Excel Picture lookup...
  4. S

    Display an image that is referenced by a hyperlink

    How can I display an image that is referenced in a different worksheet? For example, sheet1!A1 contains a link to an image file, just a hyperlink to a local jpg. On sheet2, in some arbitrary cell, say B5, I would like to display the image that is referenced in sheet1!A1, i.e. sheet2!B5 shows...
  5. P

    Insert Image

    Hi there, Im new to the board ... I want to post a question with an Image to help explain what I need... however im not sure how to Insert an Image. The Image is on my desktop in a JPEG ... how do I get an URL of this. I know its prob simple but Im still learning :biggrin: Thanks very much
  6. N

    Insert Picture from File increases Excel File Size more than the picture you inserting - WHY????

    I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB - why is this disproportionate growth happening and is there a way around it - I dont want my Price...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top