Greetings!
I am currently trying to design a userform that would show different images (images are already in place on a worksheet) depending on which text box is active. The code is roughly like this:
Private Sub Txt_Le_Enter()
' << SHOW A PICTURE FOR Le PARAMETER >>
Txt_Le.ForeColor = vbBlack
End Sub
Private Sub Txt_W_Enter()
' << SHOW A PICTURE FOR W PARAMETER >>
Txt_W.ForeColor = vbBlack
End Sub
Private Sub Txt_D_Enter()
I' << SHOW A PICTURE FOR D PARAMETER >>
Txt_D.ForeColor = vbBlack
End Sub
I can't seem to find a way to load a picture to the image box and I keep getting an Object required error. I also can't make use of file referencing because what I am trying to do requires that only one file is to handled, and needing to reference files would not be very favorable, thus I need the pictures to be immediately available on the Worksheets. I believe this has been a problem of many users before but most of what I see online are referring to MS 2003. Perhaps some updates on MS 2007 have been incorporated to make this easier, I just don't know. Sorry for being such a noob at this, but I hope to receive answers.
I am currently trying to design a userform that would show different images (images are already in place on a worksheet) depending on which text box is active. The code is roughly like this:
Private Sub Txt_Le_Enter()
' << SHOW A PICTURE FOR Le PARAMETER >>
Txt_Le.ForeColor = vbBlack
End Sub
Private Sub Txt_W_Enter()
' << SHOW A PICTURE FOR W PARAMETER >>
Txt_W.ForeColor = vbBlack
End Sub
Private Sub Txt_D_Enter()
I' << SHOW A PICTURE FOR D PARAMETER >>
Txt_D.ForeColor = vbBlack
End Sub
I can't seem to find a way to load a picture to the image box and I keep getting an Object required error. I also can't make use of file referencing because what I am trying to do requires that only one file is to handled, and needing to reference files would not be very favorable, thus I need the pictures to be immediately available on the Worksheets. I believe this has been a problem of many users before but most of what I see online are referring to MS 2003. Perhaps some updates on MS 2007 have been incorporated to make this easier, I just don't know. Sorry for being such a noob at this, but I hope to receive answers.