+ Reply to Thread
Results 1 to 2 of 2

Filling form fields via worksheet dropdowns, user update via form, change form color

  1. #1
    Registered User
    Join Date
    05-03-2010
    Location
    Texas, US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Filling form fields via worksheet dropdowns, user update via form, change form color

    I have been trying to do this using various sources around the web, and I am frustrated to no end.

    I have to make a form that pulls information from a worksheet and populates the fields based on the worksheet allowing the person to switch records using either of two drop down boxes, or gives the person the ability to type a number in one if the number they want is not there making a new record. I need it to update all fields at the time they select the drop down including the other drop down box, or whenever they re-open the form.

    Then they need to be able to change the data in only 3 of the fields, Part, Place and Person, not completion status, and they can't change the notification number for the order and vice versa.

    If they pull up a record that does not have the person populated, it changes the background color of a frame to red, if it is completed, change the background color of a frame to match the rest of the form.


    I know this is a tall order, if anyone can help me out even on one part I would really appreciate it.

    On a separate note I need to find out how to make the form sort the dropdown boxes in numerical order when selecting.

    Attaching worksheet.
    Attached Files Attached Files
    Last edited by Demosthenes&Locke; 05-10-2010 at 02:34 PM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Filling form fields via worksheet dropdowns, user update via form, change form co

    Demosthenes&Locke
    The first step is to remove the rowsource
    and add this to the userform
    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