combobox

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

hi
i am trying to create a combobox containing a list of names
i want the list to default to a "dummy" value when the workbook is opened
How do i do this?

thanks

kevin
 
You would need a macro for that, assume that you use the combo box from the
control toolbox,
and that the linked cell is A2 in Sheet2

Private Sub Workbook_Open()
Worksheets("Sheet2").Range("A2").Value = "Your_Dummy_Value"
End Sub

Right click the little excel icon to the left of the filemenu and select
view code or press
Alt + F11 and double click ThisWorkbook
That's where the macro should be
 
Back
Top