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

Рет қаралды 38,547

Күн бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
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:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 39

@excelisfun 10 жыл бұрын

Thanks for the video! Such magic with VBA!

@ExcelVbaIsFun 10 жыл бұрын

Thanks, ExcelIsFun. Yes Excel sure is magical. Thanks for showing us all that.

@BS2Dos 7 жыл бұрын

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?

@sollapalooza 7 жыл бұрын

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

@lorencbellovoda568 5 жыл бұрын

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.

@lunfaitang1459 10 жыл бұрын

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!!!

@ExcelVbaIsFun 10 жыл бұрын

yes, with a combobox, you do just that! You can type OR select with mouse. It's fun!

@Unknown-rv9eu 10 жыл бұрын

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.

@cinanu 10 жыл бұрын

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

@danaaron5883 2 жыл бұрын

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

@yusufsmile9770 9 жыл бұрын

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

@prasadraoylnv8791 5 жыл бұрын

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

@yusufsmile9770 9 жыл бұрын

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

@LanceYeun 7 жыл бұрын

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?

@ExcelVbaIsFun 7 жыл бұрын

+Lance Yeun can we see your code? When you debug through, is there possibly an extra or a missing backslash, such as C:\imagesmypic.jpg or C:\images\\mypic.jpg ? Also make sure you use a \ and not a /. Hmm other than that I'd need to see the code I think. Thanks Dan

@fauza4679 3 жыл бұрын

How to do if next n previous image ?.

@krn14242 10 жыл бұрын

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?

@ExcelVbaIsFun 10 жыл бұрын

Let's look into it, krn14242. Nothing's impossible, only certain things are difficult or may take time to create. :)

@krn14242 10 жыл бұрын

Did it. Works just like your video explains except I copied and pasted charts as pictures.

@arielzabatecuizon5147 3 жыл бұрын

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

@fundidor64 8 жыл бұрын

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

@constructioncost 3 жыл бұрын

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

@michaelavelar7052 5 жыл бұрын

Are you available to answer questions?

@SniperScoutXIV 2 жыл бұрын

Hi ,thanks for information .. I had a simple question .. in the moment when you have chosen the column with the number of picture which represent the pre-designated ,what if we have variable number of list to set for pictures .. for example a person who has different number of pictures in a month how he should code ?

@ExcelVbaIsFun 2 жыл бұрын

Hi Sin, I guess it would depend on your setup, how you want to fill the combobox (whether by RowSource or using a loop and the .AddItem method) and the specifics of your sheet. Would you like to send a demo wb to me to look at? You can reach me at dan@excelvbaisfun.com Thanks Dan

@SniperScoutXIV 2 жыл бұрын

@@ExcelVbaIsFun Thanks for your reply sir. I will send you a screenshot, Thanks a lot. 🖤

@umairanwar1634 3 жыл бұрын

@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.

@ExcelVbaIsFun 3 жыл бұрын

Hi Umair, Please remove Option Explicit from the top of your module in order to not have to declare every variable. Thanks Dan

@scottmarshburn5143 10 жыл бұрын

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.

@ExcelVbaIsFun 10 жыл бұрын

Probably, there may be an additional activex control somewhere one can pop into the userform after activating or installing.

@scottmarshburn5143 10 жыл бұрын

I got it to work. I put Hyperlinks in the named range for each video then used this code in the combo box click event Private Sub ComboBox1_Click() Dim Sht1 As Worksheet Set Sht1 = ThisWorkbook.Sheets("Sheet1") Sht1.Cells.Find(ComboBox1.Value).Hyperlinks(1).Follow End Sub ExcelVbaIsFun

@ExcelVbaIsFun 10 жыл бұрын

Great job, Scott!

@shakirkhilji1405 5 жыл бұрын

thanks. Sir,

@paolomorpurgo3757 3 жыл бұрын

Grazie, funziona bene

@ExcelVbaIsFun 3 жыл бұрын

Bene! So glad it helped!

@antoniocano5956 2 жыл бұрын

I only can see first column!! why?

@saffetaltun833 Жыл бұрын

Resim üzerinde iken sağ klik ile açılan pencerede en altta yer alan "Özellikler" tıklayınız. Güvenlik sekmesini tıklayınız, hemen altında "Nesne Adı" karşısındaki resim adresini kopyalayıp excel'e yapıştırınız. Bu şekilde yaptınız mı? Teşekkürler.

@peyko6970 10 жыл бұрын

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.

@ExcelVbaIsFun 10 жыл бұрын

Can you send me what you've got so far to Excelvbaisfun@gmail.com and I'll have a look, Peyko? Thanks! Dan