following discussion on this post:
The code allows me to add a button with an image. But I would like to be able to use the dynamic fields of the PDF.
Off the button is in the foreground...
As this is my first message here and I don't see any place to make it, i Want to say Hello word and thanks for the amazing job all you are doing for teaching us.
I have a question with a macro that works well, but I can't adapt it to improve what I want.
I have a book that the first sheet is...
Is there a way to change the box/arrow attached to a drop down list, to an image/shape?
Basically, instead of clicking on the arrow & box to activate a drop down list, there's a small image or shape that can be clicked. Same functionality as the regular drop down list, just change how it's...
I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log".
Also on that New Job Log sheet, I have two non adjacent columns.
On the left, starting at C5 is an empty column of cells.
Maybe a silly topic, but I'm still novice and quite unsure about some details.
I have a Userform. Left side column has the menu, consisting of 7 options/"buttons". Those buttons are actually images which change when their area is hovered. E.g. they are originally blue, the hovered state is...
I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel.
And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190)
Now, one would...
Hi, I am trying to create an email in outlook using VBA.
In the email i want to include text and a formatted table from the spreadhseet.
In addition i want to add an image/shape to the BOTTOM of the email, but I can't seem to get it to land there.
Here is the code i have managed to put...
Worksheet_SelectionChange event doesn't fire if I change the selection from a cell to an image.
Does it only fire if a cell is selected (it seems to be the case, but I thought I'd check)?
Private Sub Worksheet_Activate()
Application.EnableEvents = True
I have a program that inserts various square images onto the same size cells, on one particular sheet.
From the code on a form, I want to disable all the images, to remove the grab points thus obviously
preventing them from being moved, resized, etc.
I also want to be able to click...
I have a spreadsheet with tons of images and have to demo said spreadsheet to clients. Instead of scrolling and scrolling and scrolling, is there a way to click a button, or use a dropdown to change (load/remove/replace) and image? I would prefer to load the image from my desktop, rather than...
I need a macro that I have no idea how to even start making.
I have multiple images in multiple subfolders. The file structure looks like this:
I currently have thousands of folders with each of them having up to 10 .jpg image in them. My goal is to create a macro that goes over all folders, and for each of them, converts all .jpg files inside it into one PDF (1 img/page). I have successfully made the macro for one folder, so...
I'm looking for a way to have my buyers take photos and have Excel look in a folder for the photos.
Below is an example of current code i use. But I would like a quicker way to have Excel look for a photo. To code this for 200 photos would take a long time.
The product for it to look up...
I have an excel file which lists the stamp sets that I have. This catalogue is used to locate a particular stamp.
I want to be able to open an image file associated with that stamp set. I am using the "insert link" function.
This works after a fashion ... ie: it works only for that...
as you can see i have an image as a background in excel but this image has been converted as if it becomes the sheet itself, thus allowing to select cells just above the image itself, can someone tell me how to do this in another image?
I have some VBA code that finds named ranges throughout a workbook and saves those ranges as images.
The code works great, but the resolution of the images is not that great. If you do a manual screen capture of the range and put that image next to the image created from the macro, there is a...
I was hoping someone could help with some ideas. I have an Excel report with multiple linked pictures, one after another in a vertical layout. Each of these linked pictures points to a named range, and each of these named ranges points to a specific pivot table. Some of these...
I want a button in Excel that allows user to choose an image in their personal drive, through browsing the file location. Once they select the photo, it should create and save a copy of this photo into a shared folder, then put the new file path of the image into a cell. (This new...
I have a workbook that has 1500 itmes as inventory and items going out and coming in everyday.
I have a userform which i have bult to manage this with ease all items linked to an itemcode. I would like to display the item image as well in the same userform when item is recalled by item code...
Good morning all, I've seen a few posts on here but haven't found a situation similar. On Sheet1, I have a list of all employees. On a local drive I have a picture of all employees which I would like to hyperlink to the name...that's the easy part.
My userform has a combobox that's populated...