ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selecting/Adding data from Multiple Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/79815-selecting-adding-data-multiple-worksheets.html)

Paul23

Selecting/Adding data from Multiple Worksheets
 
Private Sub CommandButton4_Click()

ListBox2.RowSource = "R11:R15"

End Sub

Hi,
With this Code and pressing a button i get the data shown on a list box
within a userform from the active worksheet. However, I need it to add the
data from multiple worksheets and show it too me on the userform!

Thanks


All times are GMT +1. The time now is 02:04 AM.

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