VBA Drop Down Menu Question

[MiceElfandEye]

I have a drop down menu and corresponding macros for people to navigate around a large workbook, my question is before the macro runs to take them to the appropriate tab can it return the Drop Down to say MENU (essentially returning it to a resting state)

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("b2")) Is Nothing Then
Select Case Range("b2")
Case "Menu 1": Menu
Case "Dashboard": MenuDash
Case "Step 0": MenuStep0
Case " Step 0 Test": Menu0Test
Case " Step 0 etc": MenuStep0etc

End Select
End If
End Sub

This is the truncated version as I thought I'd save everyone from reading a complete list of macros.

 

[mrmmickle1]

Yes.

If your Dropdown is in the cell B2 then you just need to change the value:

Range("B2") = "Whatever you want in the cell"

If it's an actual dropdown something like this will work:

[FONT=Courier New][COLOR=#3d3d3d]Sheets("Sheet1")[/COLOR][/FONT].Shapes("Combo Box 1").ControlFormat.ListIndex = 1 'The index of the item you want to select

 

[MiceElfandEye]

It is a Data validation list. Where would I want to place Range("B2") = "Whatever you want in the cell" in the code? Basically I just want them to have it say menu if they go back to that tab later.where