Results 1 to 7 of 7

Thread: Table Form, Not Userform

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Feb 2014
    Posts
    74

    Lightbulb Table Form, Not Userform

    Hi, And thanks for fielding:

    [EXCEL]
    I'm trying to pull up the form that appears when the quick access toolbar "Form" button is clicked. My problem is that I cannot find any code that allows this and instead I'd have to create a userform which is redundant and unnecessary or I'd have to manually click on the Quick Access Form button.

    Do you know how to get excel to open the Table Form without needing to reference a userform in VBA?

    My table is entitled "Table89".

    Please, show me the way.

  2. #2
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: Table Form, Not Userform

    What is your trigger to show the form going to be? How can it be quicker than clicking a button on the QAT?

  3. #3
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: Table Form, Not Userform

    Regardless of the answer to that question, is this what you're looking for?

    Code:
    ActiveSheet.ShowDataForm

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Feb 2014
    Posts
    74

    Re: Table Form, Not Userform

    vbfbryce,

    The table is set up with 7 columns, when the Form button on the QAT is selected a self-generated form appears, I would like to use that form in order to circumvent creating a userform and the VBA code that follows it just to do what that button on the QAT does.

    I've tried recording the step, but Excel will not recognize what I'm doing.

    I tried the code you supplied, but it gave me a run-time error 1004

  5. #5
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: Table Form, Not Userform

    That code is exactly what I recorded when clicking on the QAT form button. It does demand that your cursor be in a cell in a valid "list range."

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Feb 2014
    Posts
    74

    Re: Table Form, Not Userform

    Yes, I tried that too. For some reason it's still not working. My work computer is running 2007, could this be the issue?

  7. #7
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: Table Form, Not Userform

    Could be, maybe @Westconn1 can assist. I think he's back a couple of version as well.

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width