On Oct 22, 10:27*am, wx4usa wrote:
On Oct 22, 10:22*am, Dave Peterson wrote:



You could use a macro.

This goes in a General module--not behind a worksheet and not behind
ThisWorkbook.

Option Explicit
Sub Auto_Open()
* *userform1.show
End Sub

Change userform1 to the real name of your userform.

wx4usa wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? *Is there a way to make it automatically re-appear on
opening? Or did I lose it?

--

Dave Peterson

Thanks Dave and Sheeloo !!

Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?