Hi ,
Do you mean you want the form to show?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
UserForm1.Show
End Sub
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
<http://www.ready-reports.com


"Gus Chuch" wrote:

How would you set focus back to a form once a new cell has been clicked ?
Iv tried the following but no luck
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
UserForm1.TextBox1.SetFocus
End Sub
Any ideas?
--
thank You
gus