98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Custom Button
microsoft excel courses - Custom Button
Resolved · Low Priority · Version Standard
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch between workbooks ni EXCEL.use Alt-TAB to switch between workbooks. |
