picture

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...

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...

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...

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...

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...

Hi everyone, this is Francis Ogwal, I made a population Pyramid using Conditional formatting Data Bar with City in the middle, Number of Males on the right and females on the left, i want to copy it and paste it into word to write a report but the bars are not being shown unless i link it has...

Hi, Is it possible to write a code line that pastes a picture from worksheet A to worksheet B, whose name starts with "Sheet.....". I have multiple sheets named "Sheet1", "Sheet2", "Sheet3" etc. and I only want to copy&paste one picture to the first sheet that comes up first. and I can't use...

Hi, I'm not sure how to refer to a picture of a chart that was copied from excel and pasted into powerpoint. The macro copies 4 charts in total and pastes them into one slide. I looked at the selection panel and they are named Picture 1, Picture 2, Picture 3 and Picture 4. I tried referring to...

Hi all, I have failed in trying to find this information via searches on this forum and Google so here are my questions. Using VBA MS Office 2011 for Mac: Can you hide the title bar? Is it possible to get a picture to be inserted into a userform? No matter what size or format I try I keep...

What up?

I would like to replace 45 icons looping n = 1 to 45 using Worksheets("Print Label").Shapes.Range(Array("Icon " & n)) with another picture Worksheets("Print Label").Shapes.Range(Array("Choice")) I tried using the macro recorder to copy the selected shape and then right-click on the shape to be...

I have been creating a 24 page workbook for simple accounting for a non profit group. I've updated the pages and used the "Save As" option from books volume 1 (initial) to volume 5. Now when I try and open my volume 5 I get a long list of error and it asked me if I want to correct them yes or...

I have an excel sheet containing multiple pictures with object names "Picture 1", "Picture 2", etc. The number of pictures is given by a number in cell A8 I would like to select the pictures one at a time. Currently I have Do While numpic < Range("A8").Value...

Hello guys, I used code already existed and changed it for my needs but I have troubles with adding function for counting how many labels per each row will be printed with zebra printer. Here below is picture of table (Table6) which I am using as data. Label is on different sheet: VBA Code...

I set listbox items to load picture in the picture box. Selecting an item in listbox is slow, the higher the size of the jpg file, the longer it takes to load, which do not give room to select another item quickly. is there any solution to this?

I'm trying to determine if a cell contains a comment with a picture. While I tried this way and it failed, any which way that works would be fine. I found this code: <code>Set shp = Range("C4").Comment.Shape if shp.Fill.TextureType = msoTextureUserDefined then end if</code>...

Hello. I try to make a chart, but I have a problem I can not solve. I need a little help and I'd be glad if you help me. The chart should look like I did in the picture. I divide the diagram into 8 parts, which are divided into five more. My idea is that these 5 parts represent a percentage of...

am trying to upload a picture and then rotate it and move it to specific location but i cant seem to get it to rotate. i have this code bec. i want to save with document the picture <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight...

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...

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...