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 VBA Training and help » VBA in office 2007
VBA in office 2007
Resolved · Low Priority · Version Standard
Thu 21 Feb 2008, 10:16Delegate Nathan said...
Nathan has attended:
Excel VBA Intro Intermediate course
VBA in office 2007
Hi Carlos
I'm thinking of upgrading to office 2007 from 2003, are you aware of any differences with the code/layout in the new office package?
Also, do you remember our conversation about counting coloured cells?
Thanks
Nathan
Fri 29 Feb 2008, 16:02Trainer Carlos said...
Count Cells according to Colours & VBA in Office 2007
Nathan
I have run the code I usually use in the course in 2007 and there have been no problems.
The Visual Basic Editor (VBE) hasn't had any major changes
As for the code to count coloued cells do the following:
1. Open the VBE and create a Module in either the document where the code is to run or in the Personal Macro Workbook.
2. Copy the following code into the module:
[b]
Public Function CountByColour(MyRange As Range, MyColorIndex As Integer, _
Optional OfText As Boolean = False) As Long
' This function return the number of cells in MyRange with
Training information:
|
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:New Normal WorksheetDo you want all your worksheets to confirm to a certain look? Then change the Defaults!!! |
