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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.