Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck in a loop
I am using a drop down menu. When an item from the drop down menu is
selected, certain cells are formatted differently. This is done immediately using: Private Sub Worksheet_Change(ByVal Target As Range) Each selection is sent into a seperate sub which first clears any current formatting and then formats the cells. The problem is that this unformatting and then formatting continues until I have to hit "esc." Is there a way to run it only once per selection of the drop down box? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck in a loop
You probably need to disable events while your code runs. E.g,
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False ' ' your code here ' Application.EnableEvents = True End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "CWillis" wrote in message ... I am using a drop down menu. When an item from the drop down menu is selected, certain cells are formatted differently. This is done immediately using: Private Sub Worksheet_Change(ByVal Target As Range) Each selection is sent into a seperate sub which first clears any current formatting and then formats the cells. The problem is that this unformatting and then formatting continues until I have to hit "esc." Is there a way to run it only once per selection of the drop down box? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck in a loop
Works great! Thanks Chip.
"Chip Pearson" wrote: You probably need to disable events while your code runs. E.g, Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False ' ' your code here ' Application.EnableEvents = True End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "CWillis" wrote in message ... I am using a drop down menu. When an item from the drop down menu is selected, certain cells are formatted differently. This is done immediately using: Private Sub Worksheet_Change(ByVal Target As Range) Each selection is sent into a seperate sub which first clears any current formatting and then formats the cells. The problem is that this unformatting and then formatting continues until I have to hit "esc." Is there a way to run it only once per selection of the drop down box? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to put a loop in a macro? | New Users to Excel | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
Loop gone crazy | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
hysteresis loop | Charts and Charting in Excel |