Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Copy 2D array to another Vba module

Hello ı created tableData() 2d array in named "list" module by getlist() function. I want to copy tableData() array to main sub. I think firstly ı have to call and run function in main sub afterwards copy. But ıdk how to do it could you help me? I hope problem is clear.

'list module
Public Function getlist()
Dim tableData() As String
End Function

'Main Module
Sub Main()
Dim partlist() As String
partlist() = list.tableData() ' ıdk :)
End Sub

>Solution :

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

Public tableData() As String
Public Function getlist()
'any operations with array tableData() 
End Function

Sub Main()
Dim partlist() As String
partlist() = list.tableData() ' ıdk :)
End Sub
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading