Results 1 to 7 of 7

Userform Listbox For User Entry?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-24-2005
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    378

    Userform Listbox For User Entry?

    I have an application I am trying to help a coworker complete. We use 150 to 200 "bulk item codes" for process paramater specifications.

    What she would like to do is to create a userform to pick the 10 to 20 bulk item codes produced for the day and enter the production units.

    Say the spreadsheet looks like:
            A                B
            Bulk            Prdtcn
     1      Item             Units
    
     2     1400051          15,243
     3     1400118
     4     1400139           9,386
     5     1400228
     6     1400230
     7     1400231          11,236
     8     1400232
     9     1400236
    10     1400290      
    11     1400401
    12     1400404           7,235
    13     1400406
    14     1400411
    she would like to be able to enter the bulk item code (not let her enter an item that is not in the above list) and the corresponding production units into a userform that would look like:
          Bulk             Prdtcn
          Item             Units
    
         1400051          15,243
         1400139           9,386
         1400231          11,236
         1400404           7,235
    I have been trying to read the VBA Help file on using the ListBox without much success.

    Is the ListBox the correct tool, and if so, how do I use it in this application?
    Last edited by DCSwearingen; 09-18-2007 at 04:31 PM.
    Thanks!
    Dennis

    I am using Windows 7 and Office 2007, all of my posts are based on this.

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