The Data Form - A question

[MartinL]

Can I force the Data Form (built in or Walkenbachs version) when a certain tab is opened.

I will also need to ensure the cursor is placed on A1 or it wont work.

If so how?

Martin

 

[jeffreybrown]

Hi Martin,

Is this what you are looking for?

Change the userform name to match yours and right click the sheet you want this activated on and view code >> paste

Private Sub Worksheet_Activate()
    Application.Goto Range("A1")
    UserForm1.Show
End Sub

 

[MartinL]

Hi Jeff

No, I am trying to get the Excel built in "Data Form" utility to open when I goto the Tab called "Master"

Basically I am trying to coerce users into using this feature.
Of course they can say get stuffed and scroll down 30000 rows to add data in at the bottom, but there you go.

users will be users.

Martin

 

[jeffreybrown]

Hi Martin,

Okay, sorry about that one then...not sure how to do it.

 

[RoryA]

Private Sub Worksheet_Activate()
    Application.Goto Range("A1")
    Me.ShowDataForm
End Sub

 

[lenze]

Maybe these will help
http://www.ozgrid.com/forum/showthread.php?t=28611&page=1

http://www.mrexcel.com/forum/showthread.php?t=83853

lenze

 

[MartinL]

rorya

my hero

where can I find a list of that kinda stuff?

Martin

 

[RoryA]

In the Object Browser in the VBEditor.