Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inputbox entries (XP SR1)

    The InputBox allows a single entry, is there aan InputBox facilty that will allow multiple entries? Many thanks.

    F

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Inputbox entries (XP SR1)

    You could have the user enter entries separated by (for example) semicolons:

    strNames = InputBox("Please enter one or more names, separated by semicolons.")

    You can parse the result into an array using Split. Alternatively, you could create a userform with a multiline text box.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inputbox entries (XP SR1)

    Thanks for that. I was intending to prompt a user for numerical entries, 5 in all, and then they would be assigned to specific cells in a sheet..

    F

Posting Permissions

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