Category Archives: Drop Down List

No Thumbnail

Excel VBA Set Underline (Sample Code + Download)

In this article I’ve provided an example on how you could use VBA to set underlines for cells and ranges. There are 4 different underline style the user can select from: Single Double Single Accounting Double Accounting For more information about the different underline types and their associate VBA code please

No Thumbnail

Excel VBA, Set Vertical Alignment (Sample Code)

In this article I will provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical  alignment will be applied to the cell below the drop down list. You can download the file and code related to this article here. Upon

No Thumbnail

Excel VBA Get Underline (Sample Code + Download)

In this article I’ve provided an example on how you can get the current underline style used in a cell. When the user presses the Run button the program loops through the cells in row 1. In row 2 the type of underline used is printed. There

No Thumbnail

Excel VBA, Wrap Text On/Off

In this article I will explain how you can use VBA to modify the wrap text property of a cell or range. I will also explain how you can use VBA to check the current status of the wrap text property for a cell or

No Thumbnail

Excel VBA Drop Down Lists Using Data Validation

In this article I will explain how you can create drop down lists using data validation.   Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA)   You can download the file and code related

No Thumbnail

Excel VBA, Shrink To Fit On/Off

In this article I will explain how you can use VBA to modify the shrink to fit property of a cell or range. I will also explain how you can use VBA to check the current status of the shrink to fit property of a cell or

No Thumbnail

Create Invoice/Bill Using VLOOKUP (Step by Step Tutorial)

In this article I will provide a step by step tutorial to explain how you can create an Invoice using VLOOKUP. I’ve explained the basics of using VLOOKUP in VLOOKUP, Excel Functions so I’m assuming you are familiar with the function. You can also download the complete Invoice file here. Jump To:

No Thumbnail

Excel VBA, Get Vertical Alignment (Sample Code)

In this article I will provide an example on how to find cells with a specific vertical alignment. You can download the code and file related to this article here. The user selects the desired vertical alignment to find from a drop down list: After pressing the run button

No Thumbnail

Excel Drop Down Lists

Generally speaking there are 3 types of drop down lists in Excel: Form Control ActiveX Data Validation. In this article I will brieftly explain each one and provide links to more detailed explanation of each. – Form Control (Combo Box): These drop down lists which are