PDA

View Full Version : Solved: Data Form



chem101
11-17-2010, 06:38 AM
Hello Everyone,

Is it possible to access an Excel Data Form on worksheet 1 that references a table on worksheet 3 without the user ever have to go to or see worksheet 3? If yes, please advise.

Thank you for your assistance!

Bob Phillips
11-17-2010, 07:31 AM
Yeah, just create a simple macro with this code



Worksheets(3).ShowDataForm


and assign it to a button.

chem101
11-17-2010, 07:45 AM
Thanks, but I'm getting a Run-time error 9: Subscript out of range
Do you know how to correct this?

Bob Phillips
11-17-2010, 09:35 AM
Preumably you don't have a worksheets(3).

chem101
11-17-2010, 09:54 AM
Here's the code I'm using:

Sub ShowCustomerDataForm()

wksCustomerListing.Activate
wksCustomerListing.ShowDataForm

End Sub
I get the error message without the .Activate as well.

Thank you!!

Bob Phillips
11-17-2010, 10:27 AM
Without seeing the workbook, I don't have many (any?) suggestions.