brunces
07-14-2005, 01:01 PM
Friends,
Please, if possible, take a look at my "attached file" for you to understand what I want. :)
I need to know how to do 3 things:
1) When clicking on "Add client to DB" button:
Check if the SSN typed in A5 already exists in the data base below, in column A (maybe using VLookup, I don't know).
- If so, this new record can't be added to the data base (a MsgBox will tell me that).
- If not, the record can be added.
2) When clicking on "Delete client from the DB" button:
Check if the SSN typed in A5 already exists in the data base below, in column A (maybe using VLookup, I don't know).
- If so, delete the entire line where that SSN is found.
- If not, a MsgBox will tell me that the SSN doesn't exist.
3) When clickin on any of both buttons...
Excel shows me everything it's doing while macros are running (range, copy, select, paste, etc). Is there any way to tell Excel not to show me those actions during the running macros? So that, when I click any button, Excel does what it has to do without showing me what it's doing.
That's it, fellows. I hope you can help me.
Any doubt, ask me, please. :)
Thank you very much for your attention.
Hugs for all.
Bruno
Please, if possible, take a look at my "attached file" for you to understand what I want. :)
I need to know how to do 3 things:
1) When clicking on "Add client to DB" button:
Check if the SSN typed in A5 already exists in the data base below, in column A (maybe using VLookup, I don't know).
- If so, this new record can't be added to the data base (a MsgBox will tell me that).
- If not, the record can be added.
2) When clicking on "Delete client from the DB" button:
Check if the SSN typed in A5 already exists in the data base below, in column A (maybe using VLookup, I don't know).
- If so, delete the entire line where that SSN is found.
- If not, a MsgBox will tell me that the SSN doesn't exist.
3) When clickin on any of both buttons...
Excel shows me everything it's doing while macros are running (range, copy, select, paste, etc). Is there any way to tell Excel not to show me those actions during the running macros? So that, when I click any button, Excel does what it has to do without showing me what it's doing.
That's it, fellows. I hope you can help me.
Any doubt, ask me, please. :)
Thank you very much for your attention.
Hugs for all.
Bruno