U_Shrestha
02-25-2008, 01:53 PM
Hello all,
I have attached a sample workbook. Basically, I have 3-sheets, viz.: DataPullUpPage, AuditIssues, StationInfo.
DataPullUpPage is the page in which a user enters a Station No. in B2. As Station # is entered, B3:B10 is filled with formula, which pulls station addresses from StationInfo Page.
Now, the audit issues page has all the itemized audit issues. A peculiar thing about this is that the table data looks like an MS Access table. Please note the Station Number, the issues belong to a particular Station Number.
To view audit issues for each Station, there are two buttons in DataPullUpPage and both has VB code. Now, the form's button pulls up data from AuditIssues Page but the ActiveX fails to do so. I even set the TakeFocusOnClick to false.
The ideal solution for me would be, as soon as a user enters a Station Number in B2 of DataPullUpPage and presses ENTER, the audit issues should fill in below A13:K13.
If this is not possible, then I would like to use ActiveX command button to have this result. Thanks.
I have attached a sample workbook. Basically, I have 3-sheets, viz.: DataPullUpPage, AuditIssues, StationInfo.
DataPullUpPage is the page in which a user enters a Station No. in B2. As Station # is entered, B3:B10 is filled with formula, which pulls station addresses from StationInfo Page.
Now, the audit issues page has all the itemized audit issues. A peculiar thing about this is that the table data looks like an MS Access table. Please note the Station Number, the issues belong to a particular Station Number.
To view audit issues for each Station, there are two buttons in DataPullUpPage and both has VB code. Now, the form's button pulls up data from AuditIssues Page but the ActiveX fails to do so. I even set the TakeFocusOnClick to false.
The ideal solution for me would be, as soon as a user enters a Station Number in B2 of DataPullUpPage and presses ENTER, the audit issues should fill in below A13:K13.
If this is not possible, then I would like to use ActiveX command button to have this result. Thanks.