Darren
11-02-2008, 01:03 PM
Hi all
Been a while :hi:
This problem reverts to an upgrade i would like to do on a excel document i created with the help of Malcolm and Xld and a few others. i have attached the working file but i would like to upgrade it a little.
Happens at the moment...When the user clicks the file from the desktop shortcut the file open up and the user must enter a phone number in the active box. Then by pessing the tab key the current program searches the database and if it finds a match then it returns the information back to the sheet in the relevant boxes. This information is stored in DATABASE BUILDING worksheet. To test copy and paste a telephone number from this worksheet then press tab.... this all works well and data is put into the Tax Reciept correctly. To cut a long story short i would like to upgrade a little this is what i would like to happen
When the user open the Excel document from the desktop a Message Box opens asking for the Telephone Number before opening the workbook. The user then enters the Telephone Number and clicks OK. On clicking ok VBA will search for the telephone number in the Database Building worksheet and if found return the result in C7 in the worksheet DEFAULT PICKUP PROTECTED LAYOUT :help if no result is found return a message box that says "Number not in database would you like to create a new entry" yes or no. On yes open New Customer.xls if no close workbook
Not that cluded up but help would be appreciated
Kindest regards
Darren
South Africa
Been a while :hi:
This problem reverts to an upgrade i would like to do on a excel document i created with the help of Malcolm and Xld and a few others. i have attached the working file but i would like to upgrade it a little.
Happens at the moment...When the user clicks the file from the desktop shortcut the file open up and the user must enter a phone number in the active box. Then by pessing the tab key the current program searches the database and if it finds a match then it returns the information back to the sheet in the relevant boxes. This information is stored in DATABASE BUILDING worksheet. To test copy and paste a telephone number from this worksheet then press tab.... this all works well and data is put into the Tax Reciept correctly. To cut a long story short i would like to upgrade a little this is what i would like to happen
When the user open the Excel document from the desktop a Message Box opens asking for the Telephone Number before opening the workbook. The user then enters the Telephone Number and clicks OK. On clicking ok VBA will search for the telephone number in the Database Building worksheet and if found return the result in C7 in the worksheet DEFAULT PICKUP PROTECTED LAYOUT :help if no result is found return a message box that says "Number not in database would you like to create a new entry" yes or no. On yes open New Customer.xls if no close workbook
Not that cluded up but help would be appreciated
Kindest regards
Darren
South Africa