Solved: Data Form

[chem101]

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]

Yeah, just create a simple macro with this code

[vba]

Worksheets(3).ShowDataForm
[/vba]

and assign it to a button.

[chem101]

Thanks, but I'm getting a Run-time error 9: Subscript out of range
Do you know how to correct this?

[Bob Phillips]

Preumably you don't have a worksheets(3).

[chem101]

Here's the code I'm using:

[vba]Sub ShowCustomerDataForm()

wksCustomerListing.Activate
wksCustomerListing.ShowDataForm

End Sub
[/vba] I get the error message without the .Activate as well.

Thank you!!

[Bob Phillips]

Without seeing the workbook, I don't have many (any?) suggestions.