is there anyway to autorun the macro as soon as the data is entere instead of pressing a button ??
C cassy01 Sep 24, 2004 #1 is there anyway to autorun the macro as soon as the data is entere instead of pressing a button ??
C CBrine Sep 24, 2004 #2 You can use the Worksheet_Change(ByVal Target As Range) Event as trigger to do processing, although I would need more information. Would it be a range of cells, if so, what range or column
You can use the Worksheet_Change(ByVal Target As Range) Event as trigger to do processing, although I would need more information. Would it be a range of cells, if so, what range or column
C Chip Pearson Sep 24, 2004 #3 Cassy, You can use the Worksheet_Change event procedure in the appropriate worksheet's code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Cassy, You can use the Worksheet_Change event procedure in the appropriate worksheet's code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
