+ Reply to Thread
Results 1 to 4 of 4

How can i Create an Excel UserForm??

  1. #1
    Registered User
    Join Date
    05-12-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2003, 2007, 2010 and 2013
    Posts
    56

    How can i Create an Excel UserForm??

    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

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How can i Create an Excel UserForm??

    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

  3. #3
    Registered User
    Join Date
    05-12-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2003, 2007, 2010 and 2013
    Posts
    56

    Re: How can i Create an Excel UserForm??

    i want Create an Excel User Form by visual basic (VBA)....

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: How can i Create an Excel UserForm??

    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1