Getting Started With Excel UserForms

With programming, you can create an Excel UserForm, to use for data entry. Click a button, and the data is stored on a hidden worksheet, and the form is cleared out, so you can start a new entry.


See the Completed UserForm

There are step-by-step instructions and videos on my Contextures website, that show you how to create a basic UserForm.

Someone suggested that it would help them get started, if they could see the finished product first. I agreed, and there is a new video on the web page now.

This video shows the completed form, how it works, and where the data is stored.

I hope this inspires you to get started with UserForms!


You may also like...

6 Responses

  1. nats says:


    Can anybody give me a video tutorial or link on how to create a Userform that could Add, Update, Delete, View Record or Spreadsheet? but here’s the challenge

    1. The CELLS in my INPUT DATA ENTRIES (Colored Red), are not in one column unlike with the sample video.
    Could this be done into different CELLS/LOCATIONS?

    2. User will be using two (2) FORMS. Its exactly the same FORM but FORM2 has just VALUE COMPUTATION on the other page.

    see my sample form: FACEBOOK

    3. The last Row being transferred on the Record/Worksheet when its already full, should continue on the next Record/Worksheet

    4. All Datas entered can be Edited; Added; Cleared and will be automatically reflected in the Record/Worksheet and the User
    could do scrolling of the updated record by just clicking the NEXT and PREVIOUS button.

    Just like exactly as this video:

    5. User could also do a Search for specific record by giving the TD_No. Please see my sample form

  2. SpreadsheetPro says:

    Nice tutorial – I start to like Google Spreadsheets more though when I need user input, their built in forms connectivity is very convenient.

  3. Raymond Roy says:

    In the userform 2 columns, is there a video or instructions to follow with?

    Thank You

    Raymond Roy

  4. Jon Peltier says:

    As you know, I have a rather extensive charting utility on the market (gratuitous plug alert). I’m slowly stumbling along the process of converting it for use on a Mac. Whatever they tell you about Windows-Mac “compatibility”, don’t believe it. they know not of what they speak.

    For example, Windows uses Points and Mac uses Pixels. This means that a Windows UserForm will be shrunken to the point of illegibility on a Mac. If you’re converting one dialog, resizing and repositioning the form and all of its controls isn’t too daunting a task. But if you have over a dozen, that’s one monstrous headache. So I put together a little code that modifies the UserForm designer window, changing the size of the dialog, and uniformly sizing and positioning its controls. The current relative size of a dialog is saved as a constant in the dialog, so it can be reverted or adjusted as desired. Not bad.

    Then of course, if the UserForm’s controls have any pictures, the form may have errors when opened in a Mac, and it may even lose all of its controls. So I added a routine to export the pictures as image files, and remove the pictures from the controls. Hey, a blank control is better than a gronked dialog.

    While I was at it, I’ve added functions that import and export selected dialogs and other VB components, that list properties of all of the controls on a UserForm, that allow you to do a find-replace on the names of the controls (still working on making the appropriate adjustments to the code), and that allow you to replace a control of one type for a control of a different type (listbox for combobox, for example, or option buttons for checkboxes).

    So I guess pretty soon I’ll have a blog post about all this, with a downloadable UserForm utility, and hopefully a Mac version of my software.

  5. Don Leverton says:

    Thanks so much for your Userform examples!
    They really got me started with what I consider to be a rather ambitious new project using Excel. (I’m usually an “Access guy”, but that isn’t an option in this case)

    I’m having a little trouble with printing a userform that contains an AcroPDF AxtiveX control.
    The PDF displays just fine on the userform, but is BLANK when you print the form out.

    I have posted a screenshot and further details here:

    Any Ideas?

    Thanks, Don

Leave a Reply

Your email address will not be published. Required fields are marked *