Results 1 to 22 of 22

Userform - complex idea

Threaded View

  1. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,754

    Re: Userform - complex idea

    A few changes:

    You are using a listbox for the first Name, but there can only be one person for a specific duty for a specific week, so I changed it to a textbox.

    I changed the names of your listboxes and textbox so when reading the code you can tell what they are (e.g., ListBox1 is now listboxDuty).

    I replaced your checkbox with a button to make the replacement. IMHO this is a better user interface design, unless you want them to be able to go back and forth, checking and unchecking the box. That didn't seem likely but if so, let me know.

    I added a Close button.

    Edit: I didn't preview before posting and I see that some conversation has happened since I started. I did not address your duplicate problem. Will revisit that as time permits now that the issue is a bit clearer.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 08-28-2013 at 01:37 PM. Reason: update
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Have no idea how to get this done. Please help.
    By Leonard99321 in forum Excel General
    Replies: 4
    Last Post: 08-17-2013, 06:03 AM
  2. Complex userform with user-populated listbox
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 72
    Last Post: 01-23-2013, 04:18 PM
  3. Creating a "complex" userform
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2010, 04:04 PM
  4. Complex Userform - Step by Step
    By oberon.black in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 11:08 AM
  5. Checking a complex userform for blank entries
    By WillRn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2005, 07:05 PM

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