Archive for the ‘Excel Tutorial’ Category

Excel Vba: Create Invoice And Entering Data Quickly Through Userforms

November 15, 2017 Leave a comment

        In this invoice template ,the userforms that contains textbox,listbox and buttons are used to enter quickly data of customers and products.
Ago,requested data can be searched in list through the text boxes . Then, when the list item is double-clicked or when the enter key is pressed, the item’s data is entered in the sheet
The created invoice can be copied to selected record sheet.

Example workbook can be downloaded here


Excel Vba : Filtering Between Two Dates Using Userform

November 12, 2017 Leave a comment

On the userform, when the dates (start date,end date) are entered in text boxes of userform and if report button is pressed the userform elongation effect is activated and listbox appears.The found results are listed on the listbox.
When choosing a date to add into text boxes,the date userform was used instead of date picker control .

Download sample workbook