VBA Walkthrough #1 - Purchase Order Generator
17.8 هزار بار بازدید -
6 سال پیش
-
One of the best ways
One of the best ways of learning VBA is to take a look at completely functioning macros & code to see how others approach a problem. In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed:
– How to create unique userforms which allow users to input information in a separate window.
– Usage of VBA userform toolbox items such as Label, ListBox, TextBox, and Buttons.
– Coding related to specific events (when an item in a list is chosen, or a button is clicked).
– Declaring variables, and using worksheet functions in VBA.
– Populating Purchase Order sheet with relevant product information based on user’s selections.
Download the Purchase Order Generator workbook to follow along.
Also, this is the first video lesson with HOMEWORK!! Please feel free to complete the assignments in the worksheet and send to [email protected] for feedback.
– How to create unique userforms which allow users to input information in a separate window.
– Usage of VBA userform toolbox items such as Label, ListBox, TextBox, and Buttons.
– Coding related to specific events (when an item in a list is chosen, or a button is clicked).
– Declaring variables, and using worksheet functions in VBA.
– Populating Purchase Order sheet with relevant product information based on user’s selections.
Download the Purchase Order Generator workbook to follow along.
Also, this is the first video lesson with HOMEWORK!! Please feel free to complete the assignments in the worksheet and send to [email protected] for feedback.
6 سال پیش
در تاریخ 1397/11/30 منتشر شده
است.
17,868
بـار بازدید شده