Thread: Userform - Picture inserted into image1 control based on what is populated into t

I am in the same boat http://www.excelforum.com/excel-prog...print-out.html hard to find what you are looking for but i found this your textbox6
could be Textbox1 and combo box textbox2
I have not got it to work yet..only the picture designated to be there if nothing else is
anyway if you get it working please post as i am still looking
thanks john

Assume you have an image control on the userform named Image1

Private Sub Textbox1_Exit()
  
if lcase(me.Textbox1.Value) = "yes" and _
     lcase(me.Textbox2.Value) = "yes" then
     
 me.Image1.Picture = LoadPicture("C:\MyPics\checkmark.jpg")
  
elseif len(trim(Textbox1.Value)) > 0 and _
         len(trim(Textbox2.Value)) > 0  then
       
me.Image1.Picture = LoadPicture("C:\MyPics\Cross.jpg")
  
else
       ' do nothing until there is a value in each textbox
  end if
end sub

Private Sub Textbox2_Exit()
  
if lcase(me.Textbox1.Value) = "yes" and _
     lcase(me.Textbox2.Value) = "yes" then
      
me.Image1.Picture = LoadPicture("C:\MyPics\checkmark.jpg")
  
elseif len(trim(Textbox1.Value)) > 0 and _
         len(trim(Textbox2.Value)) > 0  then
      
 me.Image1.Picture = LoadPicture("C:\MyPics\Cross.jpg")
  
else
       ' do nothing until there is a value in each textbox or
       ' me.Image1.Picture = LoadPicture("C:\MyPics\Cross.jpg")
  
end if

end sub

I used the exit event of each textbox to trigger the code. You may want to use something else - that's up to you.

--
Regards,
Tom Ogilvy

What's the question?

Shorten your title as well, currently it makes no sense