ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   passing data (https://www.excelbanter.com/excel-programming/414406-passing-data.html)

ranswrt

passing data
 
I have an array that collects data using a userform. How do I pass that
array to another userform to use?
Thanks

joel

passing data
 
You userform is private

You need to delcare the array outside the sub as public. Remove any
declarations inside your subs where the array is being used.

Public abc(10)



"ranswrt" wrote:

I have an array that collects data using a userform. How do I pass that
array to another userform to use?
Thanks


ranswrt

passing data
 
Thanks

"Joel" wrote:

You userform is private

You need to delcare the array outside the sub as public. Remove any
declarations inside your subs where the array is being used.

Public abc(10)



"ranswrt" wrote:

I have an array that collects data using a userform. How do I pass that
array to another userform to use?
Thanks



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

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