Hi
I am using a RefEdit bx as shown below.
When the box is clicked to start, I want to always show Sheet1 for the
selections.
The following code did not work. I got this code by using the macro
recorder, so must have missed something else that's needed.

What would work here?


Private Sub RefEdit1_DropButtonClick()

Sheets("Sheet1").Select
Sheets("Sheet1").Show

End Sub

Thank you,
Keith