vba customising number format
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 VBA Training and help » VBA: customising number format

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

VBA: customising number format

resolvedResolved · Low Priority · Version 2003

replyReply Fri 24 Apr 2009, 11:27Delegate Richard said...

Richard has attended:
Excel VBA Intro Intermediate course

VBA: customising number format

Hi Carlos,

Thanks for a great course.

Can you automate/write a macro to effectively produce a customised format for a number, for example, putting brakets around negative numbers?

Is it simply a case of recording the action and reviewing the results?

Thanks,

Richard

For upcoming training course dates see: Pricing & availability

replyReply Fri 24 Apr 2009, 17:19Trainer Carlos said...

RE: VBA: customising number format

Hi Richard

The simple answer is Yes.

If you record yourself setting the number format by either using the standard or the customised formats then all you need to do is adapt that code into your procedure.

Hope this helps

Carlos

Fri 1 May 2009: Automatically marked as resolved.

 

Excel articles

· A Quick Guide To Conditional Formatting In Excel 2007/2010
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· Identifying Suitable Candidates For VBA For Excel Training
· Let Excel look after the pennies, and the pounds will take care of themselves
· How To Create An Excel Formula Using Data From Several Worksheets

Please browse our web site to find out more about
excel training in uk and other Microsoft training courses.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

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

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy