microsoft excel courses - custom button
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Custom Button

microsoft excel courses - Custom Button

resolvedResolved · Low Priority · Version Standard

replyReply Wed 1 Aug 2007, 11:14Delegate Nicholas said...

Nicholas has attended:
Excel 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

For upcoming training course dates see: Pricing & availability

replyReply 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

 

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard