Thanks for this, this seems to be the easiest way.

-----Original Message-----
Put the data in textboxes or labels, put it in a listbox
or combobox. There
are many ways you could do it. Listbox seems like it
would be the easiest
to me


Listbox1.RowSource = "Sheet1!A1:B24"

--
Regards,
Tom Ogilvy


"Danny Sowden" wrote in message
...
I have used the VBA UserForm and can now display a form
which opens up when i click a picture and also has a
close
button on it. How do i now get the form to display the
data from the worksheet i.e. A1:B24. I just want the
form
to pick up certain data depending on which picture the
user selects.

Thanks,

Danny


.