Random texts are a great, they can be used as the filler texts where you want to show representational text. Or we can generate random text to use as password generator that is secure and hard to crack by notorious users using formulas in excel. You can use Excel formulas […]
Convert Html To Text In Excel
November 26, 2024
VBA code to convert html to plain text, this helps us to make the html code readable by stripping all the html tags from the html code and printing/rendering the output of the code. When we have a an Excel sheet with cells containing html. We can batch convert them […]
Adding A ToolTip To Any Cell In Excel
November 26, 2024
When we make a form for others to fill out it is helpful to have some tips to let them know what the cell represent so that they fill out the correct details in the cells. The tooltip or infotip or a hint is a common graphical user interface element. […]
VBA Message Box Set No as Default Button
November 26, 2024
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the message box appears if user hit Enter button, Yes or Ok will be activated. Sometimes, this is not desired. In case […]
Hide Unhide Worksheet Tabs in Excel
November 26, 2024
How to hide/Unhide Sheet Tabs in Excel? By default Excel displays the tabs at left hand side bottom. Using this Users can navigate to any worksheet present in the workbook. Note: This article is not able hiding sheets. It is only about sheets tabs. If you chose now to display […]
Remove Drop Down data validation list from Excel & VBA
November 26, 2024
How to Remove DropDown box in Excel & VBA? If you know the cell address that you are going to delete, then it is easy. But there are times, where we might want to delete all the validation lists in a Sheet or a Excel Workbook. Here is the code […]
[VBA] Read Values in Data Validation Drop Down List
November 26, 2024
[VBA] Read Drop Down List Values Add a data validation drop down list as explained in this page. Skip this step if there is already a validation created in the Worksheet & You just want to read the items in the list. We are programming with a Excel sheet. How […]
Excel VBA List Files in Folder – Dir in Shell
November 26, 2024
List Files in Folder using Excel VBA To get list of files in a directory, just give the folder path as input to this function. It will read the file in the folder one by one. Then display the file names. In this sample code, we will get list of […]
2 Methods To – Remove #N/A Error in Excel – Vlookup
2 Ways to remove #N/A Excel error in VLOOKUP, Worksheet or VBA Macro code. Fix Vlookup #n/a & Excel #n/a common errors formula. Hide n/a Excel Error.
Add Excel VBA Drop Down Data Validation List
November 26, 2024
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here – but all are related to validation list. Note: Combo-box control that also display list of values in dropdown is not explained in this page. Adding Drop Down […]