Writing data to worksheet using UserForm

Описание: In this video which is the 1st part of the series, we discover the UserForm object and then we use them to read and write data to the worksheet. The Userform helps you build a professional looking Graphical User interface with which you or others can interact easily. VBA allows you to put so many controls on the UserForm not only to accept inputs but to also display data which may read from a worksheet, a database or any other compatible file. You also have access to lot of Events and Properties which you can use to make a brilliant application.

Watch the video to understand reading and writing data to a worksheet using the UserForm object in detail.

----
00:00 Intro
01:18 Inserting a UserForm
01:51 ToolBox
02:26 UserForm Sections
02:52 Properties Window
07:09 Launch a UserForm
08:07 Placing controls on a UserForm
13:25 Adding images to CommandButtons
15:30 Control Tip Text
16:35 Accelerator property. Assign a shortcut key
17:28 TabIndex property
18:36 Launching UserForm from a procedure
19:31 Show method of UserForm
20:34 Modal vs Modeless UserForm
21:35 Launching UserForm from a button in a worksheet
23:24 Access UserForm Code Module
23:55 UserForm Events
24:43 Add code to UserForm
30:24 Adding data to worksheet using a UserForm
32:12 Outro
----

Equipment/Software used for recording and editing this video

Camera: https://amzn.to/3IJqos7
Microphone: https://amzn.to/3MhA5Ac
Lights: https://amzn.to/3ptjxLV
Camtesia: https://techsmith.z6rjha.net/SidRecom...

Disclaimer: The above are affiliate links. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!

Connect with me on social:

LinkedIn:   / siddharthrout  
Facebook:   / msexcelvba  
Instagram:   / altf11ninja  
X: https://x.com/AltF11Ninja
Stackoverflow: https://stackoverflow.com/users/11405...

#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel