Excel VBA Forms Part 13 - Image Controls

By Andrew Gould

[vipuljain]

Great tutorial man. Love how you painstakingly made so many videos to educate the world. By the way, love the accent. I just hate the Indian accent (even though I am one) in tutorial videos.

[paulkakou]

Well done! All my thanks for your fabulous work.
But the file link points to "Pt12 - Toggle Buttons.zip". While the video is about "Excel VBA Forms Part 13 - Image Controls".
Thanks for updating.

[MrAhmadAdli]

Hi Andrew, I can’t thank you enough for this great tutorial, it’s fantastic. I have one question please, if I want to save the image itself not the file path, in this case what should I do?

[Husky_Passion]

28:10 *.png also, since i only use png, better quality, and can do transparancy

[zozozozo]

Great! and big Thx to you! Excel GrandMaster

[idevsl]

I didn't know about existing DropButton on a TextBox. It looks like a refEdit Control.

[bruce]

Hi Andrew a quick question please.

When you wrote the code
Result = fd.Show
If Result = 0 Then Exit Sub

When I ran the new code I didn't pick an image and I pushed the button while it was still labeled "Open" and I got a built in error message.

FilmPics
File not found
Check the file name and try again.

I put an on error statement in the code, but it doesn't seem to trap this error, you just get the error generated by windows or excel whichever is doing this.

Is there a way to trap this error so I can just exit without the message or perhaps make my own message?

I'm just wondering for my own knowledge.

Thanks for your time!

[divyal]

Nice One Andrew! how to change the picture as per the name of the movie selected? Thank you very much!

[vivekroshan]

Hello Andrew Sir, I watch your videos. They are very helpful. I am newly learning excel vba. Can you please help me to solve my problem in userform I have created.

I have created a userform for incoming and outgoing filing system. The userform has several command buttons such as ADD, CLEAR, SEARCH, UPDATE, CLEAR, DELETE, PRINT and CLOSE. All are working fine. I have added a new command button "INSERT IMAGE". I have coded for that image button to save jpg file in another folder called 'photos' with file name as 'incoming letter reference No.' in textbox3.

Prior to adding 'Insert Image' button, the search button is coded with a single criteria i.e, SUBJECT IN Column A. Now image file is named as 'letter reference no. in Column D. I am not able to set two criterias for search record, one with SUBJECT AND second with INCOMING LETTER REFERENCE NO. to get image from folder called 'photos' into image box in userform.

1. I want to display jpg picture in image box with related records in other text boxes in userform with search command.

2. I want to email that picture to the concerned engineer with options YES OR NO. IN THE USERFORM.

Your help on the above problem shall be highly appreciated.

With best regards,

[caribeiro]

Hey there thanks for the video
Can you tell me why's that in the FilmPicturePath_BeforeUpdate when i type :

FilmPicturePath. my intelysense is not showing the Picture property
and not even all those picture property's that is showing on your's (4:40)

[camilo]

Hello, Does anyone know a video HOW I zoom in and out or add a horizontal and vertical scroll bar if the picture is large selected in the USERFORM? I will really appreciate this information code.

[puneetaggarwal]

Image size changes automatically when i run this userform in different computer with different resolution ..how to maintain image size in userform across different resolutions

[imranbhatti]

Nice sir Andrew....I have created a Payroll userform that calculates Pay of employees. I alos have an image control on the same useform in which I want the picture of the employee to be displayed ...the pictures are in a folder "Employee Photos" and this folder is saved in the same location where my Payroll workbook exists...now every employee photo is saved exactly with the same of the employee which is entered in "TxtEmpName" textbox. I want it to be dynamically appear in the image control when I type the name of the employee in txtEmpName. is it possible? if yes please guide me....I would be very thankful to you.

[pundirrajender]

Please advise how can we insert image on outlook email body through vba code.

[yeuduongtamhuong]

23:51, i don't understand why Result= fd.show, it's same type?

[trytohelp]

not display picture path another cell
please slove it