Excel VBA Forms Part 13 - Image Controls

[@Husky_Passion]

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

[@WiseOwlTutorials]

A good tip, thanks for sharing!

[@paulkakou4323]

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.

[@WiseOwlTutorials]

Oops! Thanks for pointing that out Paul, the correct link is in the video description now. Thanks for watching and taking the time to leave a comment!

[@paulkakou4323]

Link is ok. Thanks very much.

[@WiseOwlTutorials]

@@paulkakou4323 No problem Paul!

[@vipuljain42]

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.

[@caribeiro77]

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)

[@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?

[@victoropere2107]

awesome tutorials

[@bruce2357]

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!

[@divyal5852]

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

[@walidmechakou3554]

amazing! very helpful thanx

[@yeuduongtamhuong]

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

[@Scooter7788]

Good question: Result variable is a Integer type and that can store numeric values. FileDialog's show method returns a Long and that isn't compatible with a Result variable. The values can be 0 (if user press Cancel button or cross button for close FileDialog) or -1 (if a user press a button that confirms a selected item). I also tried and I have ad error, the Result variable must be Long type for no errors.

[@idevsl8245]

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

[@camilo11315]

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.

[@pundirrajender]

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

[@pundirrajender]

@@WiseOwlTutorials ok, Thanks

[@puneetaggarwal7549]

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

[@WiseOwlTutorials]

I'm sorry I don't know!

[@vivekroshan4946]

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,

[@imranbhatti8580]

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.

[@imranbhatti8580]

We are taught "If you don't know how to do, Ask the people who know "...Thanks Andrew this worked like a magic.

[@zozozozo43]

Great! and big Thx to you! Excel GrandMaster

[@trytohelp8757]

How To Display Image Path

[@trytohelp8757]

not display picture path another cell please slove it