Excel VBA Add or Change EMPLOYEE PICTURE or IMAGE on UserForm смотреть онлайн

Works with Excel 2016, 2013, 2010, Office 365! Click in List Box - Make UserForm Images and text Box info change . Click Button, search Hard Drive for new Image, Put New image on UserForm and on Spread sheet.

This covers 2 inter-related topics. How to change the Employee pictures in an Image control on a UserForm. AND How to make a command button that calls the Open Dialogue box, allows you to navigate the hard Drive, pick a NEW picture and then put the path & file name on the spreadsheet - then put the new picture on the form showing.
Covers the List box, ListIndex Property, and How to program it. Not as hard as it sounds... really, this is pretty easy once you know how.
---------------------------------
A SPECIAL THANK YOU to those folks who clicked on the Ads! [big smile with teeth] We video makers don't get paid by the Views... we only get paid by the clicks on the advertising... Clicking on the Ads is the BEST thank you we Video creators can get .. So... THANK YOU! [big smile with more teeth]
------------------------------------------

Click on the VIDEO TIME LINK to Go To that part of the Tutorial

SET UP SPREAD SHEET
0:00 Introduction
0:37 1. Insert Column for File Path
1:01 2. Make NAMED RANGE for List Box display
1:26 USER FORM SET UP (Controls & Property Sheet settings)
1:32 Command Buttons
1:35 Text Boxes - invisible
1:42 Image Control
1:49 ListBox
2:00 LIST BOX PICTURE CHANGE
2:14 ListBox_Click() - "Change UserForm Picture on List Box Mouse Click CODE"
2:29 List Box Explanation
2:46 LIST Command Explanation
3:11 ListIndex Command Explanation
3:23 ListBox_Click() - Step by Step VBA Code Explanation
4:26 ASSIGN PICTURE CHANGE PROCEDURE TO LIST BOX ON USER FORM
4:49 How to Make a List Box Column Invisible
5:18 BUTTON CLICK OPEN DIALOGUE BOX PROCEDURE
5:26 variable declarations
5:31 Button Click - Open Dialogue Box - Step by Step VBA Code Explanation
6:09 Complete Add Picture Procedure Step by Step explanation
7:10 Assign Open Dialogue Box Procedure to Command Button on UserForm
7:27 Closing Remarks

More Tutorials at [ https://officemoose.com ]