Set a default value to Drop Down Box

[peekbo]

Is it possible to set a 'default' value to a drop down box, so that n
matter what value was selected when it was saved, when the workboo
opens it changes to the default value?

I have a written a macro to do this for all the input cells that ar
not drop downs, but cannot figure out a way to change values in dro
down forms.

Thanks
Bria

 

[Dave Peterson]

What's the default value? The first on the list?

If yes:

Option Explicit
Sub auto_open()

Dim wks As Worksheet
Dim myDD As DropDown

For Each wks In ThisWorkbook.Worksheets
For Each myDD In wks.DropDowns
myDD.ListIndex = 1
Next myDD
Next wks

End Sub

You wrote dropdown--You used the dropdown from the Forms toolbar???