Pull Up Photos Dynamically on a Userform - Great For Employee or Product Maintenance Form

preview_player
Показать описание

In this lesson, we learn to pull up any picture we want when we change the selection in a combobox or listbox, for example. The picture doesn't bog down the workbook size, because it pulls it straight from the pc, using the file location. Fun! Check it out!!!!

Fantastic Developer Tools:
Рекомендации по теме
Комментарии
Автор

Can the photos be saved in one of the worksheet instead of using the location from computer?

sollapalooza
Автор

Thanks for the video! Such magic with VBA!

excelisfun
Автор

Is there a way to add the images to clipboard (copy) so that I may paste them onto another document?

danaaron
Автор

Thanks. How it works when picture is related to two criteria not only one. For being more clear, there are different pictures that have the first criteria the same and the second different. let say the same PIN but different Description within the context of your video.

lorencbellovoda
Автор

Sir please help, I have my image/picture inside my excel sheet. How to display it on userform? pls help. thanks.

arielzabatecuizon
Автор

Just wondering if we could do a word file instead of image ??? 

cinanu
Автор

Awesome!!! VBA is great and fun!

I wonder if we may use type function instead of clicking from drop down list to show the same result? Since practically speaking if we have more data it would be convenient to type 001 (Let's say employee I.D.) instead.

Thanks!!!

lunfaitang
Автор

hello sir can you reverse the method..now pic from the user form to spread sheet pls

constructioncost
Автор

Thanks Dan. Great idea. Wonder if you could use this to choose charts? Create a chart on a hidden tab, copy and paste as picture somewhere, then refer to it like you explained. You think?

krn
Автор

Hello Dan, learning so much from your videos!!! I have a question. I am trying to load a pdf file of an application database into a control acropdf1.

here is my code but it does not work.

Private Sub cmbapp_Change()
On Error Resume Next
Dim mypdf As String
mypdf = Me.cmbapp.List(Me.cmbapp.ListIndex, 2)
Me.AcroPDF1.LoadFile (mypdf)
End Sub
I was hoping you could shed some light on what i am doing wrong.

Unknown-rveu
Автор

Good stuff. Is there any way to configure the user form so that in addition to images, each click of the box would also pull an object like a pdf file?

BSDos
Автор

@excelvbalsfun i am working on my educational project and looking for the same thing to show photos depending on combobox drop down. i repeat the same procedure many time but failed to run the macro. the code i get is variable is not defined. as in your example, you have assume/assign a code as "myImg" what ever i put, i get the error the variable is not defind. please guide to do the necessary thing at the earliest. thank you in advance.

umairanwar
Автор

Sir, how to display family tree with photos on userform in excel vba...

prasadraoylnv
Автор

Are you available to answer questions?

michaelavelar
Автор

Can something similar be done with videos. I have some training videos that I want the user to access through a combo box in a form. When they clicked on the file name then it would start the video.

scottmarshburn
Автор

how if i want to preview a pdf file on my user form ?

yusufsmile
Автор

the file doesnt work, it doesn´t have the Vba code.  but thanks any way

fundidor
Автор

I've tried this and it works great for absolute paths, but I'd like to set up a hyperlink base and just have the file name under the image column. so in document properties i set the hyperlink base to C:\Images\ then in the cell i type image001.jpg. I've tried this out, but it keeps popping up an error saying the file can't be found even though i KNOW the files are there and i've pointed it to the right location. What am i missing?

LanceYeun
Автор

thanks for this video....good lesson...

yusufsmile
Автор

Hi again,
i have a new question for you that i really want to have some light on, because i have been trying to fix this issue for ages and i have yet to find a work-around :/
Sometimes, happens randomly it seems, i get the error: "Invalid picture", when i am trying to show a "chart" from excel on my userform. I am doing this by saving the chart to my workbook location and then exporting it onto my userform. 
It have worked for sometime, but suddenly it gives me "invalid picture" and i dont know what to do :/

Sincerely,  
Peyko.

peyko