Consulting

Results 1 to 4 of 4

Thread: Send Textbox Text to Array

  1. #1
    VBAX Regular
    Joined
    Apr 2016
    Posts
    14
    Location

    Send Textbox Text to Array

    Hello,

    İ need some help about sendin text or value to array


    code is like that

    Dim myarray As Variant
    myarray = Array(textbox1.text)
    For i = LBound(myarray) To UBound(myarray)
    'do something
    next

    thx

  2. #2
    VBAX Expert
    Joined
    Sep 2016
    Posts
    634
    Location
    ??

    myarray = split(textbox1.text)

  3. #3
    VBAX Regular
    Joined
    Apr 2016
    Posts
    14
    Location
    Quote Originally Posted by mana View Post
    ??

    myarray = split(textbox1.text)
    Sub test()

    Dim myarray As Variant
    'myarray = Array(textbox1.text)
    myarray = Split(TextBox1.Text)
    For i = LBound(myarray) To UBound(myarray)
    msgbox myarray
    Next

    End Sub

    Thanks for reply but showing some error
    Runtime error 424
    Object required

  4. #4
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    Not far
    Posts
    1,541
    That error implies you don't have an object called Textbox1.
    Be as you wish to seem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •