1. D

    VBA Loop Though Column of Data, Select Shape in offset column

    Hi. I'm trying to figure out how to loop through column "I" If it finds a cell that is blank, skip the row, move to next row until it finds a cell containing a value Once it finds a cell with a value in column "I", select the picture in column "B" of the same row. Once the picture is selected...
  2. CsJHUN

    VBA slideshow-ish

    Hi guys i would like to create a userform, which load pictures from a folder, and change the pictures every 3-4 seconds, while the user can select between 2 option button ( good or not good). And the picture name,the selected option button value would be registered below each other. The 'sleep'...
  3. willow1985

    VBA Copy visible cells as a picture

    Hello, I have a macro that filters column Q removing blank cells. Once it is filtered to show only the cells with data I am looking for a code that will copy all visible cells from Q2 down and copy them as a picture. Any idea what code I could use? Thank you for all your help! Carla
  4. D

    Insert a picture into named excel worksheets by client id vba

    Hi everyone, I have a workbook containing multiple sheets. The first sheet contains a unique 4 digit id to identify the client. Other sheets within the workbook are named after a year group so Y1, Y2, Y3 and so on.... Elsewhere on my PC, i have files that are named with the 4 client digit id...
  5. S

    Userform Picture and text selection

    Good Morning, I was wondering two things, both interrelated: 1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as...
  6. S

    Loop issue to export picture

    Hi all, I want to export a group of shapes as an image. The group consists of various shapes that are displayed / hidden based on user selection and show incident types on a map. All I want is to export this map to a JPG. I have crafted a script from various finds online, it works sometimes...
  7. A

    Drag Picture on Userform

    Is it possible to have a Picture on a UserForm and have its size change with the Form as you drag the bottom right corner ? I have this working on some other platfoms (Access, VB6) but can't seem to manage it in Excel - or the Picture flashes white bars while moving. Any help much appreciated.
  8. D

    Picture Styles

    My understanding is that the preset Picture Styles (e.g., 'Bevel Perspective') is not available in VBA, but I was wondering if someone had gone to the effort of reverse engineering what values would need to be set to which settings in order to recreate an identical effect? I've tried this in the...
  9. T

    Posting Screen Prints to Questions

    I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting? Thank you...
  10. HappyChappy

    Barcodes in Excel

    Hi having great problems with bar codes currently using a web based site https://www.barcodesinc.com/generator/index.php to generate barcodes then cutting and pasting them into excel as a picture. The site uses Code 128b for the fonts. I downloaded said font and thought it must be better to do...
  11. L

    grouping sheets and inserting a picture/shape

    Hi I wanted group several sheets and then insert a picture or shape in one sheet and hoping it will appear on all grouped sheets but when I group sheets, insert picture or shapes options are grayed out. Is that by design? Thank you.
  12. J

    Excel amortization calculation

    I have a question on mortgage payoff calculators spreadsheet its an advance formula but cant explain it so is there a way to send a picture of it?
  13. B

    Excel VBA inconsistent errors when trying to copy and paste objects from Excel to Word

    Hello All, I have some VBA code that will sometimes run just fine and sometimes will give an error. I am getting very frustrated and in need of some help ... I have tried various things, but just cannot find a solution. First ... what I am trying to do ... I have an embedded Word document...
  14. J

    Adding Paranthesis Around Multiplied Numbers in a Textbox

    Hi, I need help with creating a code where in equations that I am making, parenthesis would go around the multiplication, just like in the picture below. Here is the photo: https://imgur.com/a/kJ1YAMM
  15. L

    picture hide the text behind

    Hi I inserted a picture in a sheet. I moved the picture over a table. After that I can not see the contents of some cells. Can I put the picture in the background and move the text in front, like in Word? Thank you very much
  16. S

    Zoom in on an image (picture) displayed in workbook

    I'm using the following code to display an image in a workbook. Sub Image21() On Error GoTo ProcExit21 Dim objPicture As Picture With Sheets("Working").Cells(1, 1) ' Picture displays in cell from row, column Set objPicture = .Parent.Pictures.Insert(Sheets("Working").Cells(2...
  17. A

    Insert picture in comment box (through fill effects → picture → insert picture)

    I was able to insert picture in the past in my comments through insert comment → fill effects → picture → insert picture. But not anymore: the system is spooling and it tells me that I can do it through "work offline". I click offline and nothing happens. Anyone experienced this? I have excel...
  18. S

    Excel Image resolution change

    Hi I have an excel file that in every row I add a picture to in one of the cells. Pictures are big and I drag them to fit in one cell then I save the file . The problem is when I open the file I want to be able to drag the picture and see the info on it but the pictures resolution has been...
  19. A

    Error: Invalid Picture in Userform

    Hello all- I have a userform which is taking pictures of graphs and displaying it in excel with the below code. Occasionally I get a Run Time Error 481 Invalid Picture on the line below. What's odd is when I go in and change the name of the charts in both the excel and the vba code, everything...
  20. S

    VBA Pasting as picture not as data!!??

    Hi all I'm at my wits end so I really hope someone can help! I have a macro that I recorded that simply needs to copy the content from the active sheet (using copy and paste as I need the command button to copy as well), create a new sheet and paste the copied data there... but it's pasting it...

Some videos you may like

This Week's Hot Topics