Combo Box on Data Form

Topic

New Reply

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

45544-Diag

Reply | Quote

Replies

You cannot customise the built-in form in any way, I’m afraid.

Reply | Quote

Kerryg,

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

http://blog.contextures.com/archives/2010/08/02/mysteries-of-the-excel-data-form/

Reply | Quote

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:

45576-zeddy-pic0

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:
45577-zeddy-pic1

45578-zeddy-pic2

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

zeddy

Reply | Quote