excel data forms

Good afternoon phillb

Try :

Please Login or Register  to view this content.

HTH

DominicB

Hi phillb

I am actualy using a standard form automaticaly generated by excel

Not sure what you mean by this. If you are referring to the standard dataform (Data > Form), then this is the dialog box opened automatically by the macro I supplpied.

Can you expand?

HTH

DominicB

Hi

Open just the spreadsheet you want to affect in Excel.
Press Alt + F11
Go to Insert > Module
Copy the code from above into the large blank pane that appeared
Go to File > Close and Return to Microsoft Excel

This should then save with your workbook and run automatically every time it's opened.

HTH

DominicB

Good afternoon

If I wanted to add drop down menus relating to lists that I have, how would I go about creating these and putting them into the form???

You don't. You have to enter all the data via textboxes. If you want that kind of thing you will need to program your own using a UserForm to enter data ...

or

You could utilise John Walkenbachs own form utility.

http://j-walk.com/ss/dataform/index.htm

This is a free add-in which does support dropdown boxes. When invoked the add-in adds an extra menu item to Excel's Data menu. Details of how to set up the dropdowns can be seen here, or accessed from the forms help file :

http://j-walk.com/ss/dataform/cusomizing.htm

HTH

DominicB