View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joseph[_58_] Joseph[_58_] is offline
external usenet poster
 
Posts: 3
Default Change image in UserForm

I want to create a userform with a listbox that has 4 columns, one
column is Customer#. Each item in the list will have a related picture
of the same name (i.e. Customer# 01234 = X:\Pictures\01234.jpg) stored
in a folder on my computer.

Is it possible to have the Image control on the userform updated 'when
the item in the list is selected' rather than having to click on a
command button, so that each time you would select an item in the list,
the image on the userform would change?

Thanks,
Joe