picture

  1. M

    VBA Code to insert a picture into a cell

    Hi does any one know if you can insert a picture, file name say Tom, into a cell. So if I have the word Tom in a drop down box in cell A1. I would like the picture of Tom to appear in cell B1 and sized to fit in a cell say 100x 100. And if I change the name to say to Jack then Jacks photo will...
  2. T

    Renaming multiple copied pictures in VBA

    Hi, I am copying charts from one excel workbook (model1), and pasting them in a second excel workbook (TempFile) as a picture. There are roughly 60 of these images. I would like to rename these images. The image names keep changing, which leads to problems for the next steps. Does anyone...
  3. serge

    Concatenate formula.

    I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together from cell A1 with B1 see picture or is there another solution ? Thank you
  4. A

    Put a value to a cell only if two values of two other columns are the same

    Hello everyone, i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture. Thanks for your assistance in advance.
  5. W

    Excel VBA delete picture

    I want to delete picture based on cell value If Target.Value = "Yes" Then delete RedArrow picture should only show GreenArrow picture not both If Target.Value = "No" Then delete GreenArrow picture should only show RedArrow picture not both<strike></strike> Private Sub Worksheet_Change(ByVal...
  6. K

    Copy and Pasting Picture to PowerPoint

    Hello hope everyone is doing great! So I am trying to copy and paste these pictures with specific "names" onto specific slide onto an existing PowerPoint. Below is the code that I am currently using please let me know if I can expound in anyway. I keep getting an error message on the bold, red...
  7. K

    Select Pasted Picture

    I am trying to rename a picture that I just pasted (a copied screenshot) so that way I can consistently copy and paste and modify using the same name. So far the code I have is this: Application.SendKeys "({1068})", True DoEvents Dim PicName As Variant PicName = "Cinco Bug All Screenshot1"...
  8. T

    Picture button VBA

    I am looking to find out how to add code to my VBA script for when a picture button is clicked I have a series of picture buttons which, if I click any one of them runs through a script to confirm or deny access What I now need to do is: If the access is granted to the picture button clicked...
  9. M

    Position of Inserted Picture in VBA Code not working

    Hello, I am trying to insert a picture such that it spans the width and high of range G4:G8, which is about 1.13 in by 1.2 in according to the format graphic size & properties. Unfortunately, my picture continues to be inserted in range E4:E8 and *I DONT KNOW WHY* :mad::mad::mad::mad: This is...
  10. A

    How to add picture as a background of comment? Excel/VBA

    Hi, I Would like to add picture as a background of cell comment, When i click on the cell comment should be show with the background picture, Does anyone know how to can do it? Regards!
  11. A

    Excel table with some advantages:)

    Hello everyone, I would like to make a table in excel, First three columns will be include only text or numbers but in next two columns i want to insert a pictures (one column) and very long sentence/string (last column), when i click on cell in these column/s the picture or long text string...
  12. T

    control your sheets data filter with one sheet

    i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture
  13. T

    control your sheets data filter with one sheet

    Hello Kings of excel i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture
  14. W

    how can I insert photo within cell ranges by giving path and photo name using VBA ?

    Here is my code !! In my code, there is no error but doesn't effect, I dont know why ? Appreciate for any idea. Sub InsertPicture(PictureFileName As String, TargetCell As Range, _ CenterH As Boolean, CenterV As Boolean) ' inserts a picture at the top left position of TargetCell ' the...
  15. MFish

    Comboboxes on top of images within a userform

    Are you able to place comboboxes over an image? I have an image resembling a trailer and I want comboboxes to be on top of it looking like the selection within the combobox is a certain pallet in that location of the trailer. Possible? I've tried dragging the comboboxes onto the picture and...
  16. N

    Can't change size of "picture link" when I copy the new sheet

    Hi Everyone, I have used "picture link" to paste the data(in sheet2) from my worksheet(sheet1) And I resize that picture to bigger. After that I copy sheet2 to sheet3, sheet4 and sheet5. The picture'size (from "picture link") is equal size of worksheet(sheet1) How can I resize "picture...
  17. A

    Form Navigate

    Is there any way to have Navigation buttons (like Access record selectors) on an Excel Form? I have a Form displaying pictures.. and would like to enable Next-Previous-End. Because the picture uses the whole Form (and can be dragged smaller/larger) extra controls on the Form aren't ideal as I...
  18. MFish

    Photos in Excel linked to a folder using VBA

    Hi, I'd like to know two things... One: Is there a way I can add something in a userform (button, textbox, etc.) where I can upload a picture from a shared folder? Once you hit submit to transpose the information on the sheet it will show either the picture or a link to open up that photo...
  19. D

    Which property of the Textbox makes it resizable for the user?

    I forgot which property of the textbox makes the corner like a "hook" to be able to resize it to the user's discretion. Here is a picture of what I mean: Anyone know? Thanks for your help.
  20. F

    Picture object visibility

    Conditional formatting is great for making a separate cell display when another cell has data, can this be done with a picture ? So if an adjacent cell contains 1 or more a very small picture displays however if the cell is 0 then no picture visible ?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top