Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Combo Box on Data Form

    Hello
    I have a spreadsheet that has some lookuplists and I would like to use the inbuilt Data form within excel to enter and navigate records. Sadly it does not have dropdowns for the cells where options are available to select.

    To build an input form is a lot of work if I can somehow make the standard inbuilt version include the drop downs.

    Is there an option to do this within Excel?

    I have attached a sample spreadsheet.

    Thanking you

    Diag.png
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You cannot customise the built-in form in any way, I'm afraid.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    Kerryg,

    Look here and take note of the J-Walk Enhanced Data Form which allows data validation

    http://blog.contextures.com/archives...cel-data-form/

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi kerryg

    As Maud suggests, the free add-in from J-Walk will do the job for you, and I would recommend this too. However, you will need to make a couple of minor adjustments to your file to get it to do what you want. This screenshot shows what you would see after you install the add-in:

    zeddy-pic0.GIF

    John Walkenbach's add-in makes provision for adjusting the size of his custom Data Form. You just need to define some named constants :
    DF_WIDTH (for setting Data Form width)
    DF-HEIGHT (for seting Data Form height)
    DF_FIELDWIDTH (for setting field-caption width)
    Also, to make a field a drop-down field in the Data Form, you need to create a named range for the source data. The named range fo the dropdown must match the column heading Field name (use underscores for any spaces in the field column heading). So, in your case, you need a named range Team, and a named range Job_Type to get dropdowns on the custom form:
    zeddy-pic1.GIF

    zeddy-pic2.GIF

    I have attached a file with these adjustments so you can see the difference.

    zeddy
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •