Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAN YOU LINK A FORM IN WORD TO AN EXCEL DATABASE? | Excel Discussion (Misc queries) | |||
Link Word form to Excel source file | Excel Discussion (Misc queries) | |||
Excel Form link to e-mail | New Users to Excel | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
How to create the URL with link using the VBA form input in excel? | Excel Programming |