I put a button on a userform and double clicked on it and used this code:

Option Explicit
Private Sub CommandButton1_Click()
Me.Hide
Application.Dialogs(xlDialogFormulaFind).Show
Me.Show
End Sub



"abxy <" wrote:

Alright, i'm trying to have a command button on my userform that, when
pressed, will hide UserForm, bring up the the Find dialog box (ctrl+F),
and then, when i'm done with using find and close it, the UserForm will
unhide and return...I know this seems a little difficult, but how could
i accomplish this?

Thanks in advance mates :)

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson