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
Bookmarks