Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do when the Cell is in color jump to next cell?
Hi,
I have a worksheet with some column in blue color background & when i enter the data in this worksheet (direction Right when I press the ENTER key) I would like if the next column is in blue the cursor automaticly jump to the next column until the cell have no background color. It is Possible? Thank you very much Jean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do when the Cell is in color jump to next cell?
I guess you could use SelectionChange event code something like this...
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Interior.ColorIndex = 41 And _ Target.Column < Columns.Count And Target.Count = 1 Then Target.Offset(0, 1).Select End If End Sub Change the number 41 I used above to the ColorIndex value for your particular Blue color. Rick "jean" wrote in message ... Hi, I have a worksheet with some column in blue color background & when i enter the data in this worksheet (direction Right when I press the ENTER key) I would like if the next column is in blue the cursor automaticly jump to the next column until the cell have no background color. It is Possible? Thank you very much Jean |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do when the Cell is in color jump to next cell?
Thank you very much.
I copy that in my sheets after changing the number of the colorindex & it work beautifully. Thank you again. Jean "Rick Rothstein (MVP - VB)" wrote: I guess you could use SelectionChange event code something like this... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Interior.ColorIndex = 41 And _ Target.Column < Columns.Count And Target.Count = 1 Then Target.Offset(0, 1).Select End If End Sub Change the number 41 I used above to the ColorIndex value for your particular Blue color. Rick "jean" wrote in message ... Hi, I have a worksheet with some column in blue color background & when i enter the data in this worksheet (direction Right when I press the ENTER key) I would like if the next column is in blue the cursor automaticly jump to the next column until the cell have no background color. It is Possible? Thank you very much Jean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Cell jump | Excel Programming | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Jump to cell? | Excel Programming |