Forum Discussion
Dryan91
Jan 04, 2024Copper Contributor
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...
HansVogelaar
Jan 04, 2024MVP
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.