Wed 1 Aug 2007, 11:14Delegate Nicholas said...
Nicholas has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Intermediate course
Custom Button
Hi
How can i create a customized button, so that when it is clicked it will reverse the sign of a cell.
Thanks
Nick
Tue 7 Aug 2007, 11:31Trainer Richard said...
RE: Custom Button
Hi Nick
When you say "reverse the sign of a cell", do you mean to make it a negative number from a positive, and visa versa?
If not, please could you clarify?
If so, can you do it manually?
If so, then you can probably record it in a macro and assign it to a button. The key is to be able to do it manually.
Regards
Richard
