Userform Example & Sorting Listbox Items As AlfhabeticallyMulti-functional userform example with features such as adding, modifying, deleting, and searching data. Also in this userform, the…May 30, 2021May 30, 2021
Excel Add Item To Right Click MenuWith the context (right click) menu that we customized by VBA codes:May 30, 2021May 30, 2021
Excel Filter Columns With List BoxesI listed the column headings of first worksheet on ListBox1. The selected items from ListBox1 are moved to ListBox2 with the button…Feb 25, 2021Feb 25, 2021
Excel Display Listbox When Cell Is SelectedTo add data easier to the sheet, we’ve added a hidden listbox that displays when the cell is selected. The listbox appears right next to…Feb 16, 2021Feb 16, 2021
Excel Userform With MultiPage Control & New Menu BarWe have added MultiPage control to this Excel userform example for ease of use. There are 2 separate pages on MultiPage: Page 1, Page 2…Feb 12, 2021Feb 12, 2021
Excel VBA AutoFilter With List BoxesIn template, we filtered the data in the worksheet with list boxes on userform . We filled the data of the 3 columns that we selected into…Jan 30, 2021Jan 30, 2021
Insert Picture Into Cell & View Picture It’s Original SizeBased on the text in the cell, we created a template to insert a picture into another selected cell with VBA codes. Pictures are in the…Jan 25, 2021Jan 25, 2021
Excel Hide-Unhide ColumnsThe userform that we created to hide the columns in the workbook and unhide the hidden columns contains also a button to minimize userform…Jan 18, 2021Jan 18, 2021
Excel Dependent Drop Down ListsThe database includes products, product categories, suppliers of products and prices. Even if the data in the table is mixed, we can…Jan 17, 2021Jan 17, 2021
A Date Userform Alternative To Date PickerA useful userform that it contains many features to quickly add date to the selected active cell.Jan 11, 2021Jan 11, 2021