How to read array values from function?

Question

I have a simple Function to get and save values in array:

Function GetDataOwner()

 Dim DataOwner(2) As String

 DataOwner(0) = Sheets(1).Range("H21").Value
 DataOwner(1) = Sheets(1).Range("I21").Value
 DataOwner(2) = Sheets(1).Range("J21").Value


End Function

In other function, I would like read value:

Sub GenerateDB()

  Dim DataOwner() As String
  DataOwner = GetDataOwner()

  MsgBox DataOwner(1)
End Sub

But Excel say me error 13 type mismatch. I am novice with VBA function

You need to return the array from the GetDataOwner function: GetDataOwner = DataOwner on the line above End Function — Comintern
– Comintern, Commented Oct 20, 2016 at 18:29

AAzeeze · Accepted Answer · 2016-10-20 18:34:03Z

1

Soluce:

Function GetDataOwner()

 Dim DataOwner(2) As String

 DataOwner(0) = Sheets(1).Range("H21").Value
 DataOwner(1) = Sheets(1).Range("I21").Value
 DataOwner(2) = Sheets(1).Range("J21").Value

 GetDataOwner = DataOwner
End Function


Sub GenerateDB()

  Dim DataOwner() As String
  DataOwner = GetDataOwner()

  MsgBox DataOwner(1)
End Sub

Thanks to @Comintern

answered Oct 20, 2016 at 18:34

AAzeeze

938 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read array values from function?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related