Post has attachment
Excel Vba : Filtering Using Text Boxes

A nice filtering template.
The value in textbox is searched as part or whole in the column.
The results found are shown in the column, the other data are hidden.

https://youtu.be/Y92Kv356m0s

Sample file can be downloaded from Youtube link.

Post has attachment
Basic data analysis for beginners
Please comment what changes you want to see
https://www.youtube.com/watch?v=Po4Ol3N-5Qk

Post has attachment
Product Filtering Between Two Dates Using Userform

The products between two dates easily can be filtered through userform .
When the dates (start date,end date) are entered in text boxes and if report button is pressed the userform
elongation effect is activated and listbox appears.

The found results are listed on the listbox.

https://youtu.be/-RdSZsn2KmU

Post has attachment

Post has attachment

Post has attachment
Creating Invoice And Entering Data Quickly Through Userforms

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.

https://youtu.be/Qr-4of-38DI

Post has attachment
Excel :Fast Date Entry To Active Cell With Right-Click Menu

https://www.youtube.com/watch?v=QOhg6geNoJE

Post has attachment
Excel Dynamic Listbox

An easy way to add data into activecell.
When any cell is selected in column A, the hidden listbox appears. The data selected from this listbox is entered into the active cell.

https://www.youtube.com/watch?v=r4rICK7Jb3g

Info and example file at : https://merkez-ihayat.blogspot.com/2016/11/excel-visible-listbox-when-specific.html

Post has attachment

Post has attachment
Excel :Creating A Combobox Containing Only Unique Alphabetically Sorted Values

Sometimes unique values need to fill the combobox and need to sort alphabetic..In this way, the processes may be easier.

The unique values in Column A are populated to the combobox in this example and are sorted in alphabetic order.

https://www.youtube.com/watch?v=6yK3cj7KgqQ

Also combobox in userform can be filtered on listbox and copied results to other page.

Vba codes and to download template :https://merkez-ihayat.blogspot.com.tr/2016/07/creating-combobox-containing-only.html
Wait while more posts are being loaded