I have table in excel sheet and i want Create an Excel User Form display automatically to this table, how?
plz see attachment
Book1.xlsx
I have table in excel sheet and i want Create an Excel User Form display automatically to this table, how?
plz see attachment
Book1.xlsx
You might want to consider the data form that is built into Excel. It requires no programming. The only requirements are to get the form button activated and to have a table for the data.
I don't have Excel 2003 but there should be a data form available to use with tables.
In Excel 2010, a form button can be added to the Quick Access Toolbar and if you have a table on the sheet (insert Table forming an actual table). Click in the table then click the Form Button and all the fields (taken from the table column headers) are presented to you for filling in. This data form is basic in style but allows you to enter new records, edit old ones, do searches using criteria etc.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
i want Create an Excel User Form by visual basic (VBA)....![]()
Here are a couple of places to get started...
http://www.fontstuff.com/ebooks/free/fsuserforms.pdf
http://www.contextures.com/xlUserForm01.html
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks