| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start macro on cell change
Hi,
i would like run a macro whenever the value of a cell change.This for all the cells in a certain column. Thankyou regards Giorgio |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro on cell change
Right Click on the sheet name and select "View Code" then paste the
following code. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then MsgBox "A1 value is changing" End If End Sub -- Regards, Rocky McKinley "Giorgio" wrote in message ... Hi, i would like run a macro whenever the value of a cell change.This for all the cells in a certain column. Thankyou regards Giorgio |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro on cell change
Sorry code should have said:
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then 'Type your Macro name here MsgBox "A1 value is changing" End If End Sub -- Regards, Rocky McKinley "Giorgio" wrote in message ... Hi, i would like run a macro whenever the value of a cell change.This for all the cells in a certain column. Thankyou regards Giorgio |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro on cell change
Very interesting.
How would I cause the message box to appear for 1 second then disapear as if acknowledged? Brian Tozer Rocky McKinley wrote: Sorry code should have said: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then 'Type your Macro name here MsgBox "A1 value is changing" End If End Sub "Giorgio" wrote in message ... Hi, i would like run a macro whenever the value of a cell change.This for all the cells in a certain column. Thankyou regards Giorgio |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro on cell change
http://www.xl-logic.com/pages/vba.html
look for please wait -- Don Guillett SalesAid Software "Brian Tozer" wrote in message ... Very interesting. How would I cause the message box to appear for 1 second then disapear as if acknowledged? Brian Tozer Rocky McKinley wrote: Sorry code should have said: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then 'Type your Macro name here MsgBox "A1 value is changing" End If End Sub "Giorgio" wrote in message ... Hi, i would like run a macro whenever the value of a cell change.This for all the cells in a certain column. Thankyou regards Giorgio |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| Excel auto deleting zero at start of cell - change? | Excel Discussion (Misc queries) | |||
| start a macro or procedure based on user putting an x in a cell | Excel Discussion (Misc queries) | |||
| Macro to start when cell selected | Excel Discussion (Misc queries) | |||
| Can I start a macro from a cell by using a formula | Excel Worksheet Functions | |||
![Giorgio[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
