loadpicture

I've searched everywhere and I've tried using the tips I've come across, however I still run into isses using Thisworkbook.path. This code works fine if I use $Environ(username), and put the path, but I'm not sure the other ones in my office has the onedrive folder saved in the same location. It...

I wanted to loop through this code : Sheet1.Image1. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B2") & ".jpg") Sheet1.Image2. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B12") & ".jpg") Sheet1.Image3. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B22") & ".jpg")...

Hi all, In case anyone is interested, here is the vba for making frame controls transparent in userforms. A couple of testings of the code revealed that it is very flexible and it is stable as it doesn't use hooking or subclassing for updating the frames backgrounds when moving around the...

Hi everyone, I'm after some advice for working with Excel userforms. I have the below piece of code which allows me to import an image of a chart from a sheet into a Userform. While this works OK, most of my charts exist on Chart Sheets opposed to data sheets. Is there any easy work around to...

Greetings! I am currently trying to design a userform that would show different images (images are already in place on a worksheet) depending on which text box is active. The code is roughly like this: Private Sub Txt_Le_Enter() ' << SHOW A PICTURE FOR Le PARAMETER >> Txt_Le.ForeColor...

I'm making a userform to run on both Mac and PC. The form does stuff with pictures, and since certain functions don't exist in the Mac VBA, I identify which platform is running and the proper code is used. However, when trying to use LoadPicture() to put an image in the userform image control...

Hello I am need of help with VBA LoadPicture in a form based on a variable. My combo box is the variable = cboitem my image box is = Image1 my form is named = frmData my pics are located = C:\Bob\Inventory_Tracker\ When the user ... lets say selects item # 13200 in the combo box ... I...

Dear All, I have made a template In which i have Inserted Image(Active X Control) and put a code in duble click event to select "Image1.Picture = LoadPicture(Application.GetOpenFilename) " Its working fine but problam is file size become somuch bigger then normal even image size in kb, I can't...