Help needed 
Author Message
 Help needed


 I have the following program code:

Private Sub worksheet_change(ByVal Target As Range)
'you can specify any range for your test and any value
NotMoreThanX Range("B47:G70"), 9
End Sub

Sub NotMoreThanX(rngTest As Range, X As Integer)
Dim rngCell As Range
For Each rngCell In rngTest
   If rngCell.Value < X Then
       rngCell.Interior.Color = RGB(255, 0, 0)
       rngCell.Interior.ColorIndex = xlNone
   End If
Next rngCell
End Sub

It is supposed to highlight the boxes within the columns from B47 to
G70, if the values within any of the boxes exceed 9. However, right
now, if I want to do something additional, for example link the box,
H47 to B47, H48 to B48, and so on. That means, all the boxes from B47
to G70 would be linked with a box, from column H47 to M90, one box to
one box. Now, when say box B47 is highlighted, the box that is linked
to it, that is H47 will automatically be highlighted. Take note that
all the boxes that I mention contain formulas, which I want to keep.
Is there any way to write this code?


Fri, 25 Nov 2005 03:58:19 GMT  
 Help needed
Dear Francesco,

Why don't you use Conditional formating feature of excel
for this module. That will be more beneficial and faster
than this code.


Fri, 25 Nov 2005 05:10:11 GMT  
 [ 2 post ] 

 Relevant Pages 

1. NEED HELP --- Need help setting up page size

2. help, help, help...I'm begging here :-\ RE RE POST simple code help needed

3. Help Need Outlook98 again, I lost it and need it quickly

4. Still needing help needed with sub-form

5. Help needed - do I really need SR-1?

6. Desperate HELP NEEDED...I need to read Newsgroups in Outlook 97

7. newbie needs help, needs someone to post this to a newsgroup he cannot get to

8. Urgent Help needed: I need a data type that is only Date and not Date/Time

9. HELP - Need Expert Advice - HELP

10. Please Help, Need Macro Help

Powered by phpBB® Forum Software © phpBB Group