+ Reply to Thread
Results 1 to 4 of 4

Input multiple data into one input field (VBA)

  1. #1
    Registered User
    Join Date
    08-31-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    43

    Input multiple data into one input field (VBA)

    I have a user form which allows the input of test results quickly.

    One box is for a percentage result. If "60.23" is typed in, it will divide this by 100 and then input that into a cell in a work sheet to give 60.23%.

    Is it possible for it to do this, but also allow the user to type in:
    "60.1, 62.4, 59.5"

    So it will scan all three values, calculate an average and then divide by 100, and input into a cell?
    Mainly in the interest of saving space, I'd rather do this in one box rather than making three separate boxes

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Input multiple data into one input field (VBA)

    Try this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-31-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Input multiple data into one input field (VBA)

    That works a treat. Thanks!

  4. #4
    Registered User
    Join Date
    08-31-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Input multiple data into one input field (VBA)

    Follow up question:

    How do I turn this into a separate function? I've tried:
    Please Login or Register  to view this content.
    But it doesn't like the use of the string z as a qualifier.

  5. #5
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Input multiple data into one input field (VBA)

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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