asked on

use uerform to validated data in source sheet

Hi Experts

I need a userform front end to open up when clicking the macro button in worksheet "main"...which is visible to end user..

so when the user clicks the excel 2007 file from their desktop the workbook opens, user clicks macro button to lunch userform - the resource then types in customer account number in first field and the result is displayed in the second field. ..userform to have close button..to close down form

...so spreadsheet "source data" where the user form will be reading the data from is hidden

column A. column B.
Account Number. Organisation Name
1334788. RBC
4677883. Bank of New York

in total I have 450,000 rows of data....

Shanan212

Would the account numbers always have a 'period' at the end? such as below?

1334788.

route217

ASKER

nope thats a silky error on my part Shanan 212.. apologies...

ASKER CERTIFIED SOLUTION

Shanan212

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

route217

ASKER

shanan212

is this done via a msg box....let me test...

thanks once again

Shanan212

Yes this is done via msgbox. Let me know if it works. You can change the bottom msg as you wish.

route217

ASKER

Hi Shanan212

I am testing the code and getting a run time error 6 overflow on line 5 as above...

just to point out the source data worksheet is hidden which the vba code should be looking at colum A

Shanan212

Have you corrected it? Do you need further help?