Excel VBA Introduction Part 21 – User Forms


About this tutorial:

Video duration: 1:4:53
If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here

By Andrew Gould

– Designing a User Form in VBA is a great way to allow you users to interact with your workbook. This video teaches you how to create forms, how to add controls and manipulate their properties and how to…


  1. I have learned so much watching your videos in just a short time. I tried other teachers on youtube but found yours to the best, easy to understand, very practical. I started from part 1 and now I am in part 21. I had to stop just to give a comment. can't wait for my next project. Great work!

  2. Hi Andrew
    Thanks for fascinating turorials on Excel VBA. In Pt5 and Pt21 when I tried your prog trying to enter info from scratch into a blank spreadsheet, I ran into terrible problems with the code crashing. As a bit of a learner and after much experimenting, I found that it was trying to reach the very last row +1 ! It appeared that there had to be at least 2 cells in A1 already filled in, as in your example, then it would work. Thanks again and I will carry on with rest of tutorials.

  3. Dear Andrew, I can not believe how you can know all these things of VBA. The hypotheses are two:
    1) it's been a long time since you study this subject and have a lot of experience;
    2) you're a genius!
    I think the second is right! Thank you so much for these videos.

  4. Hi, many thanks for these very useful tutorials. I have been trying to learn and do simple coding for data entry userform but I got stuck with the way the data just being written in the same row, replacing only the previous data. Could you please tell me what was missing in my code as follows:

    Private Sub cmdadd_Click()


    Range("A1").End(xlDown).Offset(1, 0).Select

    ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1
    ActiveCell.Offset(0, 1).Value = txtname.Value
    ActiveCell.Offset(0, 2).Value = txthospnos.Value
    ActiveCell.Offset(0, 3).Value = txtdob.Value
    ActiveCell.Offset(0, 4).Value = cbotrans.Value

    End Sub

    Hope to hear from you.


  5. For those of you who are using excel 2016 64 bits and can't find the Date & Time Picker control, here's a possible solution. I downloaded the mscomct2.ocx and registered it in cmd; however, that didn't work as i still couldn't find it in the additional controls. So I got frustrated and uninstalled this 64 bit version. While I was hoping to install the 32 bit version, i accidentally installed the 64 bit version again= =BUT for some reason, the option of Date & Time Picker Control appeared in the selections of additional controls! So I think if you are experiencing this problem, you can either install the 32 bit version or do what i did=]

  6. I've made a user form similar to this, and I have sent it to friends that run the same version of excel as mine. For some reason they receive the error message "Could not load an object because it is not available on this machine". Any idea how I could fix this problem?

  7. how can you change the property of the film length textbox, so that it saves the text as a number in your spreadsheet rather than as text. New films added now have the lengths aligned to the left of the column rather than the right. Thanks very much!

  8. Yeh…! there is no additional control " mscomct2", I tried to download, but not. My desktop computer's o.s is windows 7. Even I couldn't get the filled popup window for additional controls. I am confused now

  9. Once again, amazing tutorials.

    I am useing mac excel 2011 and I am unable to add more controls to the User Form Tool box. How do I add, right clicking does not do anything, searched on internet but not found anything. How do I add a date picker?