Forum Discussion

Dryan91's avatar
Dryan91
Copper Contributor
Jan 04, 2024

How to default a cell that is governed by Data Validation to a specific value

  Hello all,   Firstly, I apologise if this has already been questioned and answered elsewhere within the community.    I require a solution that would allow me to default a cell to a specific v...
excel
Formulas and Functions
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Jan 04, 2024

Please test the following on a copy of the workbook.

Press Alt+F11 to activate the Visual Basic Editor.

In the Project Explorer pane on the left hand side, double-click ThisWorkbook under Microsoft Excel objects.

Copy the following code into the ThisWorkbook module:

Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    Range(Range("G2"), Range("F1").End(xlDown).Offset(0, 1)).Value = "PLEASE SELECT"
    Application.ScreenUpdating = True
End Sub

Switch back to Excel.

Save the workbook as a macro-enabled workbook (*.xlsm).

Make sure that you allow macros when you open the workbook.

Resources