|
|
#1
04-16-2012, 03:56 AM
|
|||
|
|||
Highest & lowest Numbers
In the attached Xls file, column “B” represent the number of employees pertain to each Department in column “A”.
As per file instruction, the end user will have to highlight the 3 Departments that have the highest (or lowest) number of employees. I want the macro to check if the end user did this or not and promote him with a message if he did not. I know only parts of the required codes and I would appreciate any help to complete it. Thanks. Code:
With Selection.Pattern
Pattern = xlNone ‘this mean it is not highlighted in any color
Call MsgBox("you have not 3 Departments that have the highest number of employees – Pls try again", vbOKOnly, "WARNING")
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Page Numbers Not Matching Chapter Numbers
|
gracie5290 | Word | 1 | 02-02-2012 11:41 PM |
|
Numbers
|
rdcrags | Word | 4 | 11-13-2011 11:11 AM |
| HELP...page numbers | BroKyle | Word | 3 | 10-15-2011 08:59 AM |
| Numbers in Words | janak | Excel | 2 | 12-19-2010 08:53 PM |
| page numbers and TOC | windon | Word | 0 | 09-09-2009 07:53 AM |
Windows Vista 
Office 2007
Threaded Mode