Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Data Forms that won't show

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there all you wizards - I wonder if anyone can solve this one?

    I am tring to get a Dataform to show using a macro button on the screen. I have recorded the macro which reads (once recorded) as "ActiveSheet.ShowDataForm"

    However, when I subsequently try to run this macro, I get the error message:-
    'Run time error '1004'
    ShowDataForm method of Worksheet class failed.

    Any ideas on how to get this to work? - any replies would be appreciated as this will be a real help in putting a large project together.

    Domigos.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Domigos,
    In your Command Buttons properties,
    set the property "Take focus on click" to = FALSE.

    If that alone does not solve the problem, then precede the show
    ActiveSheet.ShowDataForm with this instruction:

    Range("A1").Activate

    Try it
    Tom

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tom,

    I cant find a properties dialog for the button (which I created from the Forms toobar)- am I being daft?

    Domigos.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No Domigos,
    I'm not sure what "daft" means, but maybe
    that is my title...
    I apoligize for leading you down the wrong trail here.
    Am fairly new to Excel but with some experience in VBA...
    After checking out the form's type command button, it does not appear that there are any properties for it???
    I never even knew there was another type of command button. I don't know why there is.

    Sorry,
    I hope someone else can help you on this one,
    Tom

  5. #5
    New Member
    Join Date
    May 2002
    Location
    NYC
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    it's a bug in excel, stumped me for a while, check out
    http://support.microsoft.com/default...;en-us;Q213835
    for workarounds

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •