| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I automatically run a macro on data entry?
I have a table of data that I sort using a Macro. However to improve user
friendliness I would like to start this when the data in cell A20 is entered or updated. IS this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I automatically run a macro on data entry?
Yes, by using worksheet_change as follows;
Sub worksheet_change(ByVal target As Range) If Not Intersect(cell, Range("A20")) Is Nothing Then 'Call your sort macro End If End Sub -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Deena" wrote: I have a table of data that I sort using a Macro. However to improve user friendliness I would like to start this when the data in cell A20 is entered or updated. IS this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy previous cells in data entry in Excel | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Linear Mode
