Userform coding to mimic Form Button

**copernicus** · 06-16-2009, 02:31 AM

More detail than you probably need, just to explain what I want to do:

Excel 2007 (and earlier I think) has a Form button (it needs to be added to the access bar in 2007) that automatically generates a user form when invoked from within a range, automatically generating the form and navigation and criteria buttons, and the criteria button generates another form for selecting records based on the entered criteria.

I dont like the look and layout of the form however, and would like to use some combo boxes instead of the generated text boxes, some date pickers etc.

I would like to create a Userform with the same navigation and criteria functionality but my own form. Is there a way to view/access the code generated by the Form button that I could copy and modify after invoking it from within a table set up with the fields for my form?

Alternatively is there a resource that has sample userform navigation coding?

Thanks

**Leith Ross** · 06-16-2009, 02:41 AM

Hello copernicus,

Welcome to the Forum!

In Excel 2003 and earlier, the only auto generated form I know about is the "Data Form". This would automatically create a simple database management tool for finding, adding, deleting records. it would create text boxes for each of the fields in the database range. Is this the same form you are referring to?

**copernicus** · 06-16-2009, 02:52 AM

Yes. Thats the one. In 2007 "help" they just call it the Form button, but the title of the help section is "what happened to the Data Form?"

**Leith Ross** · 06-16-2009, 03:07 AM

Hello copernicus,

I can't answer your question with regard to 2007 because I don't own a copy or use it. As for the previous versions you would need to create your own Data Form with a VBA UserForm. You can't customize the Data Form controls. RoyUK, the site administrator, has a nice database manager similar to the data form that uses a VBA UserForm. You could use his a guide for your custom form.