-
Sep 4th, 2014, 12:35 PM
#1
Thread Starter
Lively Member
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.
-
Sep 4th, 2014, 12:51 PM
#2
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?
-
Sep 4th, 2014, 12:52 PM
#3
Re: Table Form, Not Userform
Regardless of the answer to that question, is this what you're looking for?
Code:
ActiveSheet.ShowDataForm
-
Sep 4th, 2014, 01:02 PM
#4
Thread Starter
Lively Member
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
-
Sep 4th, 2014, 01:07 PM
#5
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."
-
Sep 4th, 2014, 01:25 PM
#6
Thread Starter
Lively Member
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?
-
Sep 4th, 2014, 01:32 PM
#7
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|