Excel VBA - Basics videos | Excel VBA Part 21 - User Forms

Posted by Andrew Gould on 28 February 2014

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 add code the events of the form to make it respond to user actions. You'll also get an insight into how much code goes into performing even very simple validation to control what your users can do with the form.

You can increase the size of the video:

Full screen mode for YouTube

You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.

You can also increase the quality of the video:

Changing resolution

You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.

Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.

This page has 1 thread Add post
17 May 20 at 13:49

Hello Sir,

I would like to thank you for the wonderful training on all the topics which are posted on this webiste.

I'm trying to learn Excel VBA Introduction Part 21 - User Forms, however unable to proceed with this video, because whenever i click on "Additional control" from tools/toolbox option, nothing happens ( i mean window doesn't pop up). As mentioned in video, I also tried to download Microsoft Visual Basic 6.0 Common Controls. However after installing this nothing worked. 

I currently have MicroSoft office Home and Student 2016 installed on my computer with 64 bit. 

Could you please help me resolve this problem. 

Regards,

Naresh Rameshwar

 

18 May 20 at 06:42