Populating VBA array from a textbox

Question

I am trying to get the value of a textbox and save it to a string array by clicking a button. I am getting a syntax error on the name(0) = TextBox1.Text line. I will be making it a dynamic array once I figure out how to do it (that's why I have a num variable as well because the button can be clicked multiple times).

Am I doing something wrong here?

Private Sub CommandButton1_Click()
   Dim name(10) As String
   Dim num As Integer

   ' Debug.Print TextBox1.Text

   name(0) = TextBox1.Text
End Sub

Goos van den Bekerom · Accepted Answer · 2014-09-18 08:36:03Z

2

'Name' is a built in name for excel.

Try:

Private Sub CommandButton1_Click()
   Dim testArray(1 to 11) As String
   Dim num As Integer

   ' Debug.Print TextBox1.Text

   testArray(1) = TextBox1.Text
End Sub

EDIT: Changed the name of the array.

edited Sep 18, 2014 at 8:36

answered Sep 18, 2014 at 8:17

Goos van den Bekerom

1,4933 gold badges20 silver badges33 bronze badges

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

3 Comments

Goos van den Bekerom Over a year ago

Hmm. could you printscreen the error and add it to your question please?

Goos van den Bekerom Over a year ago

or wait, test this first: change the word 'name' it could be that it is a built in excel function or something and that could be causing the error

zyrae Over a year ago

OMG! You're right. name is a built-in function. Time to properly name my variable now. Thanks a lot!!!!

Collectives™ on Stack Overflow

Populating VBA array from a textbox

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related