Open userform2 and register if the user is opening the workbook for the first time....

[raghuprabhu]

I have a work book with two worksheets. One is to input data “Sheet1” and other one to hold the details of the users “Sheet2”. It has two forms “Userform1” and ”Userform2”

When the user opens the workbook,

If the user is not in the “Sheet2” then
Open Userform2, input the users details
Save and close and open Userform1
Else
open Userform1
End if


Ps the form "Userform1" opens automatically. Click "Close" and then go from there..

I am trying to sort this and was finding it a bit tricky.

Thank you

Kind regards

Raghu

[raghuprabhu]

I have been able to solve this thank you

Please Login or Register  to view this content.