Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
running some VBA code in response to data entered in a cell
hello again
Can anyone tell me if it is possible to trigger some VBA code when a number entered in a particular cell on a worksheet is less than the number in another cell?. I dont know if cells have events linked to them such as mouse down etc Thanks Ian |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
running some VBA code in response to data entered in a cell
Mantrid
You could use the worksheet_change event like so. Checks a value in A1 and if below 10 it colours B1 red Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("A1")) Is Nothing Then If Target.Value < 10 Then Target.Offset(0, 1).Interior.Color = RGB(255, 0, 0) Else Target.Offset(0, 1).Interior.ColorIndex = xlNone End If End If End Sub To install right-click the sheet tab and select 'view code...' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "mantrid" wrote in message ... hello again Can anyone tell me if it is possible to trigger some VBA code when a number entered in a particular cell on a worksheet is less than the number in another cell?. I dont know if cells have events linked to them such as mouse down etc Thanks Ian |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
running some VBA code in response to data entered in a cell
Thanks again Nick
I think that is the kind of think I need. I will have a play and see if I can get it to do what I need. Ian "Nick Hodge" wrote in message ... Mantrid You could use the worksheet_change event like so. Checks a value in A1 and if below 10 it colours B1 red Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("A1")) Is Nothing Then If Target.Value < 10 Then Target.Offset(0, 1).Interior.Color = RGB(255, 0, 0) Else Target.Offset(0, 1).Interior.ColorIndex = xlNone End If End If End Sub To install right-click the sheet tab and select 'view code...' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "mantrid" wrote in message ... hello again Can anyone tell me if it is possible to trigger some VBA code when a number entered in a particular cell on a worksheet is less than the number in another cell?. I dont know if cells have events linked to them such as mouse down etc Thanks Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying running total of value entered in same cell? | Excel Worksheet Functions | |||
Envoke code with button rather than as data is entered. | Excel Programming | |||
Running a variable macro when any value is entered into a variable cell | Excel Programming | |||
Running a macro if any data is entered in a range of cells | Excel Worksheet Functions | |||
Check cell for data before running code | Excel Programming |