Hello,
I have created 2 drop down boxes using data validation command, the menu choices in the second drop down boxes are dependent on the choices in the first drop down box. Each range (range of labels for first drop down box, range of labels for second drop down box) has been given a name, and the dynamic drop down lists have been created using the OFFSET and INDEX functions. The ranger for the first drop down box is $A$1.$G$1, and the range for the second drop down box is $A$2.$G$40

A previous posting on this thread gave the VBA to reset the drop down list to the 1st item in the list:

Sub reset()

Range("A10").Value = "First Item in List for this cell"
Range("B10").Value = "First Item in List for this cell"
Range("C10").Value = "First Item in List for this cell"

End Sub

So, what is the VBA text to create a button which when selected will display the 1st menu choice in each box - the text will be 'click on the down button to select main area', and for the second box 'click on the down button to select sub-area'?
Many thanks,
Jonathan