

October 5, 2010

Hi Irfan,
So you want to display a form whilst Sheet1 is active, but the form loads data from a sheet called Data?
It doesn't matter what sheet is active, you can display the form anytime. If your form is called MyForm then calling the .Show method will display it e.g.
MyForm.Show
You must write the code that then loads the data from the Data sheet into the form.
Without seeing your workbook I'm just guessing here as to what your form is doing.
You can read about building forms here
https://www.myonlinetraininghu.....xcel-forms
and I have written more posts on forms
https://www.myonlinetraininghu.....serforms
Regards
Phil

VIP

Trusted Members

June 25, 2016

Hi Irfan
I am assuming:
1) You want to use the built-in form found in the QAT - More Commands - All Commands - Form...
2) Your data is in the Data sheet
3) You want to display the built-in form from another sheet other that the Data sheet.
Give this a try
Sub ShowForm()
Dim ws As Worksheet
Set ws = Sheets("Data")
ws.ShowDataForm
End Sub
Hope this helps.
Sunny
1 Guest(s)
