+ Reply to Thread
Results 1 to 37 of 37

userform with looping code

Hybrid View

00Able userform with looping code 02-02-2011, 09:43 PM
Marcol Re: userform with looping code 02-02-2011, 09:53 PM
00Able Re: userform with looping code 02-02-2011, 10:40 PM
pike Re: userform with looping code 02-03-2011, 07:21 AM
Marcol Re: userform with looping code 02-03-2011, 09:30 AM
00Able Re: userform with looping code 02-03-2011, 08:18 PM
pike Re: userform with looping code 02-03-2011, 11:54 PM
00Able Re: userform with looping code 02-04-2011, 07:27 AM
Marcol Re: userform with looping code 02-04-2011, 09:01 AM
00Able Re: userform with looping code 02-05-2011, 10:40 AM
Marcol Re: userform with looping code 02-05-2011, 11:27 AM
00Able Re: userform with looping code 02-06-2011, 02:54 PM
Marcol Re: userform with looping code 02-06-2011, 03:48 PM
00Able Re: userform with looping code 02-06-2011, 05:20 PM
Marcol Re: userform with looping code 02-08-2011, 10:14 AM
00Able Re: userform with looping code 02-09-2011, 09:17 PM
Marcol Re: userform with looping code 02-09-2011, 09:56 PM
00Able Re: userform with looping code 02-10-2011, 09:11 PM
Marcol Re: userform with looping code 02-11-2011, 01:02 PM
00Able Re: userform with looping code 02-12-2011, 02:04 PM
00Able Re: userform with looping code 02-13-2011, 04:39 PM
Marcol Re: userform with looping code 02-17-2011, 01:37 PM
00Able Re: userform with looping code 02-18-2011, 06:39 AM
00Able Re: userform with looping code 02-18-2011, 08:12 PM
Marcol Re: userform with looping code 02-19-2011, 11:24 AM
00Able Re: userform with looping code 02-19-2011, 09:25 PM
00Able Re: userform with looping code 02-19-2011, 11:09 PM
Marcol Re: userform with looping code 02-20-2011, 04:47 AM
00Able Re: userform with looping code 02-20-2011, 10:49 AM
Marcol Re: userform with looping code 02-20-2011, 12:35 PM
00Able Re: userform with looping code 02-20-2011, 02:49 PM
Marcol Re: userform with looping code 02-20-2011, 03:59 PM
00Able Re: userform with looping code 02-20-2011, 06:14 PM
Marcol Re: userform with looping code 02-20-2011, 08:32 PM
00Able Re: userform with looping code 02-20-2011, 08:55 PM
pike Re: userform with looping code 02-22-2011, 05:25 AM
00Able Re: userform with looping code 02-22-2011, 09:10 PM
  1. #1
    Forum Contributor 00Able's Avatar
    Join Date
    11-17-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    244

    Re: userform with looping code

    Ok, I used your recent file, and updated it try to show you what I am trying to accomplish...the real world setting. I have copied all the following information to the workbook in the "Log" worksheet so you can read it while you are looking at the layout. I have made some alterations but I have tried to explain everything.

    I originially wanted to have 2 userforms, one with text boxes & one with combo boxes. To enter the information for column's D and E, "Employee Name" & "Production #'s" respectively. After thinking about it, I guess just one userform using comboboxes (for the employee name) will work the best, as I can enter the "unit" information manually on this page without too much hassle and doing that will also assist in making sure I am entering it correctly.

    The reason I want combobox's is that I am working with 90 employees in this instance, and some names being foreign, need to have a "-" in a certain spot, and everything has to be typed correctly or I will not be able to sort the data properly, which is currently my number one issue. So I moved the "UniqueDateList" to column S, and created a "NameList" in column T, where I can input all the current employees and call this information to the comboboxes.

    *Note: I tried to use the Data Validation List function, but it doesn't help as the list is extremely long, and it will not finish what you start typing, so it is not efficient. For illustrative purposes, See cell D2.

    *This is why having that "recall" feature is really valuable, because often employees are in the same spot, but not 100% of the time, as people call off, are moved to other lines, quit, vactaion, etc.

    The rest of the sheet is going to be calling information from other workbooks (columns F-R), so that information will not have to be put on the userform. So my biggest hurdle right now will be comboboxes.

    I have added another userform "UserForm2" with comboboxes to this workbook, but the code will not work as it is from your initial worksheet, not even the updated code. But I believe I have the labels named properly as you have previously mentioned.

    *also I added a Reset button, but the code I used will not work, so I erased the code, any ideas how I can have this clear the form?
    Attached Files Attached Files
    Last edited by 00Able; 02-12-2011 at 02:12 PM.
    Providing Problems for Your Solutions
    STARS are my Punching Bag, You will be rewarded.

    In the rare event that I may help you, feel free to make me see STARS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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