event change

I am using the standard BetAngel_1 workbook that links BetFair race details directly into a spreadsheet via Bet Angel I also have 2 other sheets that generate other criteria My problem is that I have an event change macro in the BetAngel_1 sheet that is supposed to clear a range of cells if...

Hi All, The below mentioned event code changes the changed cell value to bold. I want this to be applicable to all the worksheets available in the workbook. I know i can paste this code in all the worksheets, but just want to know is there a better way of making it applicable in all the...

Hi I have a problem in using the Worksheet Change event. My code checks the Target range named 'designStatus' and performs various checks and actions if the user changes this cell. My problem comes if the Target range does not equal 'designStatus'. In this instance, I would like the system...

Hi, I have several combo boxes with varible lists of data; modifiying combobox1 causes the list in combobox2 to be updated. The problem I have is that when the code from combobox1 updates combobox2 I finish with the line below (this line just makes the combobox2.value equal the first value in...

Hello, I have been looking into this for awhile. I have a very basic knowledge with excel 2003. I am trying to create a macro based on events. The event should be triggered as soon as the user leaves the cell by clicking on a different cell or by using the arrows on the keyboard. So if the user...

I received help on something similar to this a few weeks ago, but I can't seem to get the concept enough to apply it in different scenarios. What I am needing is for an event to run when any cell in column a is changed. Here is the code I have. Private Sub Workbook_SheetChange(ByVal Sh As...