Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event that Loops
I have code which triggers off a Change Event in a Sheet. When I chang
a cell in the spreadsheet, the code copies and pastes a range withi this sheet to another range. The problem is that once the copy/past engages, the code continues be called and loops on continuously. Ho do I trigger a copy/paste using the Change Event without looping? I my only option to copy/paste to a new sheet? Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim Export As Integer Export = Range("DropDownExport") Select Case Export Case Is = 1 Range("FuelTypeName").Copy Destination:=Range("NamePaste") End Select End Su -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change event | Excel Discussion (Misc queries) | |||
Change of Row event | Excel Discussion (Misc queries) | |||
Chart Values that change based on Change event | Excel Programming | |||
Change minimumscale with the change event of a combobox | Excel Programming | |||
change event/after update event?? | Excel Programming |