Convert String Array to Integer Array from a User Input?

tinfanide · #1 12-23-2012, 09:03 AM

Code:

Sub q()

Dim vInput As Variant
vInput = InputBox("", "", "9,1,3,5,6,2,4,10,7,8")

Dim arr As Variant, a As Variant
arr = Split(vInput, ",")

Debug.Print TypeName(arr) '' String()

For a = LBound(arr) To UBound(arr)
    arr(a) = CInt(arr(a)) '' to convert string to integer
    Debug.Print TypeName(arr(a)) '' String
Next a

End Sub

This is a general VBA question.
I ask it here. I code the above in Word though.

I want to use CInt() to convert each item in an array from string to integer but it fails.

How can I convert a string array to an integer array?

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array argument in macro command	Wries	Excel Programming	2	11-20-2012 01:08 AM
How to reserve an array in a public function?	tinfanide	Word VBA	2	02-27-2012 06:51 AM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array	KIM SOLIS	Excel	5	09-07-2011 07:43 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM