+ Reply to Thread
Results 1 to 10 of 10

How to do userform with possiblity to input more than 1 string

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    How to do userform with possiblity to input more than 1 string

    Hi,

    i want to create some kind of input box with multiple inputs in VBA.
    It is not possible so maybe form can do this?

    But how? Did anybody do something similar?

    Jacek

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: How to do userform with possiblity to input more than 1 string

    Just add multiple textboxes to your form.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: How to do userform with possiblity to input more than 1 string

    Or divide the input box entry
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to do userform with possiblity to input more than 1 string

    aa dividing is nice!

    Multple textboxes will not work...

    Jacek

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,595

    Re: How to do userform with possiblity to input more than 1 string

    Or you can input array e.g.
    Not sure if this works for your language.
    Please Login or Register  to view this content.

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: How to do userform with possiblity to input more than 1 string

    Quote Originally Posted by jaryszek View Post
    Multple textboxes will not work...
    How could that not work for multiple entries?

  7. #7
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to do userform with possiblity to input more than 1 string

    If you ahve something 20 string to input and somthing 5 how you will model it ?

    I should have mechanism fo add textboxed with a button or something

  8. #8
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: How to do userform with possiblity to input more than 1 string

    It would depend on what the inputs are. If they are all related, then use the options already mentioned. If not, it's easy enough to add controls on the fly.

  9. #9
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to do userform with possiblity to input more than 1 string

    thank you very much!

    Jacek

  10. #10
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to do userform with possiblity to input more than 1 string

    jindon,

    it is working:

    Screenshot_6.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Possiblity Question
    By snowcloud72 in forum Excel General
    Replies: 1
    Last Post: 01-23-2017, 02:47 PM
  2. [SOLVED] Length of string, not value related to string appearing in input box prompt.
    By ColdDay in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-23-2014, 05:32 PM
  3. [SOLVED] Preparing text string based upon check box input in a userform
    By rreifs68 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2013, 12:31 AM
  4. Search for any string / text greater than AND for string / text less than input box
    By JaneinExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 04:18 PM
  5. Protected Toolbars Button Enabling Possiblity.
    By gajendra.gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2007, 01:28 AM
  6. [SOLVED] Vlookup when more than one possiblity
    By samenvoegen van sheets in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2006, 02:30 PM
  7. Vlookup when more than one possiblity
    By samenvoegen van sheets in forum Excel General
    Replies: 1
    Last Post: 03-03-2006, 06:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1