Excel VBA - Getting values from dynamic array - does not show real number

Question

Here is some code which shows the problem I am having:

Sub main()
    Dim V() As Long, x As Integer, temp As Long

    x = 5

    ReDim V(1 To x)

    V(4) = 0.65
    temp = V(4)

    MsgBox (temp) ' Returns value of 1
End Sub

I would like the variable temp to take in value: 0.65, but it always shows a value of 1. I am not sure what I am missing. Any help is greatly appreciated.

Abbas · Accepted Answer · 2012-01-04 16:08:50Z

2

You have declared Dim V() As Long. This means it takes in only integers. Change it to Double.

answered Jan 4, 2012 at 16:08

Abbas

6,8944 gold badges38 silver badges49 bronze badges

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

Comments

Alex K. · Accepted Answer · 2012-01-04 16:09:00Z

0

temp & V are Long integers so cannot represent floating point numbers like 0.65, simply change their type to Double which can.

answered Jan 4, 2012 at 16:09

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Collectives™ on Stack Overflow

Excel VBA - Getting values from dynamic array - does not show real number

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related