image control

I would like some help finishing the VBA code that I'm trying to piece together. I have 2 ranges of cells in a worksheet ("Data") that I would like to show individually (not at the same time) on a user form while working on another worksheet ("Input") within the same workbook. The user form...

I've tried the below VBA code to auto resize image in Excel workbook. It fits with the cell. <code>Public Sub FitPicture() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = .Width / .Height End With With...

Hi all, I've got a lot in one post really. I know what I want, but not the best way to go about it. I'm trying to eliminate the whole copy and paste procedure when creating reports. There are Red, Amber and Green scores for each section and an overall percentage score. When items get a "Red"...

Hi could anyone please let me know if there is a way to stop users resizing pictures/images in excel but still be able to move their position on in the worksheet. I am working with a touch screen display and am having difficulty with the user input being recognized as drag and drop or resize...

I've inherited a complex VBA application. It contains several userform, which have multiple image ontrols on them. Each of these image controls contains a picture file. I'd like to rescue these picture files and store them as BMP or jpg or whathever their native format is, on a separate folder...

Attached a sample code need help in retrieving the images from worksheet to Userform https://www.dropbox.com/s/nvghhjp8o83jwt0/Retrieve%20iMAGE.xlsm?dl=0 Please help Trying for more than a week time.

Hello all-powerful MrExcel board, I have been dabbling with VBA in Excel for a few years and recently rewrote several routines to make them more bulletproof. Here is what I am attempting to do: Create a new worksheet Copy the information as needed from another worksheet Format the new sheet...

Hi Guys, Does anyone have a clue how to cycle through image's in an image control called "image1" using a commandButton "CommandButton1". I have 4 images that I want to cycle through "L001, L002, L003, L004" that I need to display individually in "image1". I have the Pictures in a folder...

I would like to insert a .jpg image into an image control on a userform. The image should first be resized to match the size of the control. I do not see how to access the .height and .width properties as the following code throws an error. How can the image be resized to fit properly in the...