How to link a form to a sheet in excel
 

I have made a form in excel which gets data from another sheet containing
interlinked formulas involving repetitions.
I want only the form to be displayed on the screen with the formulas
described above to keep runnning in background and displaying final results
back onto the form fields.
However, in my case the excel sheet with formulas gets displayed.How do i
ensure that only the form is displayed.???

How to link a form to a sheet in excel
 

Hi K,

Your form is a userform?

Try:

'=============
Public Sub Tester()
Application.Visible = False
UserForm1.Show
Application.Visible = True
End Sub
'<<============



---
Regards,
Norman


"vikas k , India" <vikas k , wrote in
message ...
I have made a form in excel which gets data from another sheet containing
interlinked formulas involving repetitions.
I want only the form to be displayed on the screen with the formulas
described above to keep runnning in background and displaying final
results
back onto the form fields.
However, in my case the excel sheet with formulas gets displayed.How do i
ensure that only the form is displayed.???