Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run macro according to value of a cell
How to make a macro run automatically according to a value of a cell?
Eq: once we enter value '5' in cell G8, then a particular macro should run 5 times |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run macro according to value of a cell
hi, !
How to make a macro run automatically according to a value of a cell? Eq: once we enter value '5' in cell G8, then a particular macro should run 5 times copy/paste (or type) the following in "that" worlksheet code module (right-click its tab/name and choose: "viwe code") Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$G$8" Then Exit Sub Else Dim n As Byte For n = 1 To Val(Range("g8")) Macro1 Next End Sub hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste A Cell Formula Into A Cell With A Macro. | Excel Worksheet Functions | |||
macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
Macro for cell selection starting with Last Cell | Excel Worksheet Functions |