Excel Tips: Developer > Macro or VBA

Developer

Developer > Controls

How to add custom button to the right click/context menu in Excel?

How to apply a button to clear specific cells in Excel?

How to apply a button to open another workbook in Excel?

How to auto-center checkbox in cell in Excel?

How to change a specified cell value or color when checkbox is checked in Excel?

How to change the color of ActiveX Control button in Excel?

How to clear contents of combo box with VBA code in Excel?

How to create a Command Button to copy and paste data in Excel?

How to create buttons to open/go to certain sheets in Excel?

How to create dynamic cascading list boxes in Excel?

How to disable button after clicking once in Excel?

How to display multiple columns in combo box?

How to enable or disable button based on cell value in Excel?

How to hide checkbox when row is hidden in Excel?

How to hide or unhide a Command Button based on specified cell value in Excel?

How to make checkbox checked based on cell value in Excel?

How to make Command Button name dynamic in Excel?

How to make the background color of checkbox transparent in Excel?

How to navigate between worksheets by using drop down list in Excel?

How to only make one checkbox to be selected in a group of checkboxes in Excel?

How to populate a combo box with specified data on Workbook open?

How to populate a Userform ComboBox with all sheet names in Excel?

How to populate Combo Box with data of Named Range in Excel?

How to populate combo box with unique values only in Excel?

How to populate textbox based on combobox selection on UserForm in Excel?

How to prevent or disable typing in a combo box in Excel?

How to quickly delete multiple checkboxes in Excel?

How to quickly insert multiple checkboxes in Excel?

How to remove or hide borders from group boxes in Excel?

How to save or retain selections of ActiveX list boxes in Excel?

How to tab out of combo box to select specific cell in Excel?

How to uncheck or deselect all checkboxes at once in Excel?

How to update or insert (current) date and time by a Command Button in Excel?

How to use a Command Button to change a specified cell value in Excel?

How to use button to show hide columns in Excel?

How to use checkbox to hide or unhide worksheet in Excel?

How to use checkbox to hide/unhide rows or columns in Excel?

How to use Command Button to save active worksheet as PDF file in Excel?

Developer > Macros

How to assign hotkey to specified macro in Excel?

How to automatically run macro when cell formula result changes?

How to create a macro code to achieve find and replace text in Excel?

How to run a macro at same time across multiple workbook files?

How to run macro automatically before printing in Excel?

How to run macro based on cell value in Excel?

How to run macro based on value selected from drop down list in Excel?

How to run macro by clicking hyperlinks in Excel?

How to run macro when cell value changes in Excel?

How to run macro when sheet is selected from a workbook?

How to run multiple macros by using a button in Excel?

How to run multiple macros from right click menu in Excel?

How to run the same macro on multiple worksheets at same time in Excel?

How to run VBA macro when open or close workbook?

How to use macro to insert row below table in Excel?

How to use time delay after running a VBA macro in Excel?

Developer > Others

How to click or double click cell to open a specified user form in Excel?

How to create a yes no message box before running a macro in Excel?

How to create pop up message box when opening an Excel file?

How to display warning/alert messages if cells are blank in Excel?

How to pop up a calendar when clicking a specific cell in Excel?

How to pop up a message box upon activating/opening a specified worksheet in Excel?

How to pop up message box if cell value changes within a range in Excel?

How to pop up message box if cell value equals “X” in Excel?

How to pop up message box to display range of cells or cell values in Excel?

How to pop up message box when clicking on a certain cell in Excel?

How to pop up the cell value while clicking in Excel?

How to populate google search results to worksheet in Excel?

How to show up an input box when clicking on a cell in Excel?