Printable View
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.
What is your trigger to show the form going to be? How can it be quicker than clicking a button on the QAT?
Regardless of the answer to that question, is this what you're looking for?
Code:ActiveSheet.ShowDataForm
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
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."
Yes, I tried that too. For some reason it's still not working. My work computer is running 2007, could this be the issue?
Could be, maybe @Westconn1 can assist. I think he's back a couple of version as well.