forms

[David_UK]

I have a shared workbook on a shared drive it consists of four worksheets.

They are designed purely for recording daly cash figures i.e.

Account name Acct No. Chq # Amount Invoice numbers

I wish to create possibly using a form or VBA, a request box to appear when the sheet is opened asking for the account number and then search all sheets for the number and then either going to that cell or displaying account not found?

Any help would be great, thanks.

David.

 

[David_UK]

I have entered the program and it runs ok, only when I run the macro tho, I was hoping that when the sheet is opened, the box displays prompting the user to enter the account number. Can you help I have included the last report entered.

 

[LTunnicliffe]

Do you want to run it when the workbook is open or when a specific worksheet is open?

As far as VB references go, the way I learned is by viewing the recorded macro code, looking at what other people have written, and one VB book (Excel 2000 VBA by John Green published by Wrox).