ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Populating a VBA UserForm (https://www.excelbanter.com/excel-programming/274735-re-populating-vba-userform.html)

Danny Sowden

Populating a VBA UserForm
 
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



.



All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com