Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HELP! First time trying this, I am try an example out of a book. I'm stuck.
Do I need to have anything in the Userform Initilize? Trying to type Employee name and their picture show up in the userform. Thank you. Jennifer Private Sub tb_EmpName_Change() Dim EmpFound As Range With Range("EmpList") Set EmpFound = .Find(tb_EmpName.Value) If EmpFound Is Nothing Then MsgBox ("Employee Not Found!") tb_EmpName.Value = "" Me.tb_EmpName.SetFocus Exit Sub Else With Range(EmpFound.Address) tb_EmpPosition = .Offset(0, 1) tb_EmpHireDate = .Offset(0, 2) On Error Resume Next Img_Employee.Picture = LoadPicture( _ "C:\Excel VBA 2003\" & EmpFound & ".jpg") On Error GoTo 0 End With End If End With End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change image in UserForm | Excel Programming | |||
moving an image in a userform | Excel Programming | |||
UserForm as a Jpeg Image | Excel Programming | |||
Bmp vs Gif in Userform image controls | Excel Programming | |||
Userform Image help | Excel Programming |