Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
Can excel be set so that the active cell is highlighted while data is entered?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
When I select a cell, it is automatically highlighted with a heavy border
around it, so I'm guessing you have something else in mind... if you describe what it is, maybe we can help you out. Just so you know, whatever you describe for us will probably require VB code, so be prepared for that. -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... Can excel be set so that the active cell is highlighted while data is entered? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
"Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
"Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
"Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? Hi Jacob It seams to work but I get an error and the debugger hangs up on line 5 and it will not proceed to the next cell. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
Try
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: "Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? Hi Jacob It seams to work but I get an error and the debugger hangs up on line 5 and it will not proceed to the next cell. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
If you are willing to tolerate cell color highlighting (it means you can't
have manually colored cells on the worksheet and probably would interfere with conditional formatting as well), then why not really highlight the cell... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Union(Target.EntireColumn, Target.EntireRow).Interior.ColorIndex = 8 Target.Interior.ColorIndex = 0 End Sub -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... "Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then _ mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: Can excel be set so that the active cell is highlighted while data is entered? Hi Jacob It seams to work but I get an error and the debugger hangs up on line 5 and it will not proceed to the next cell. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
"Rick Rothstein" wrote: When I select a cell, it is automatically highlighted with a heavy border around it, so I'm guessing you have something else in mind... if you describe what it is, maybe we can help you out. Just so you know, whatever you describe for us will probably require VB code, so be prepared for that. -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... Can excel be set so that the active cell is highlighted while data is entered? . I have a simple invoice system that pretty much had to be custom made for an odd industry. Many of the cells are already surrounded by a border so when I select those cells to enter data into them the highlighted border virtually disappears. If I leave for a moment or two I have to re-select the cell as I can not see which one I have left open. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
"speerchucker30x378" wrote: "Rick Rothstein" wrote: When I select a cell, it is automatically highlighted with a heavy border around it, so I'm guessing you have something else in mind... if you describe what it is, maybe we can help you out. Just so you know, whatever you describe for us will probably require VB code, so be prepared for that. -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... Can excel be set so that the active cell is highlighted while data is entered? . I have a simple invoice system that pretty much had to be custom made for an odd industry. Many of the cells are already surrounded by a border so when I select those cells to enter data into them the highlighted border virtually disappears. If I leave for a moment or two I have to re-select the cell as I can not see which one I have left open. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 (THIS SEEMS TO BE WHERE IT HANGS UP) Jacob Set mytarget = Target End Sub |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
'Unable to recreate..Try the below version...
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then mytarget.Interior.ColorIndex = xlNone Target.Interior.Color = vbYellow Set mytarget = Target End Sub If this post helps click Yes --------------- Jacob Skaria "speerchucker30x378" wrote: "speerchucker30x378" wrote: "Rick Rothstein" wrote: When I select a cell, it is automatically highlighted with a heavy border around it, so I'm guessing you have something else in mind... if you describe what it is, maybe we can help you out. Just so you know, whatever you describe for us will probably require VB code, so be prepared for that. -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... Can excel be set so that the active cell is highlighted while data is entered? . I have a simple invoice system that pretty much had to be custom made for an odd industry. Many of the cells are already surrounded by a border so when I select those cells to enter data into them the highlighted border virtually disappears. If I leave for a moment or two I have to re-select the cell as I can not see which one I have left open. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static mytarget As Range If Not mytarget Is Nothing Then mytarget.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 8 (THIS SEEMS TO BE WHERE IT HANGS UP) Jacob Set mytarget = Target End Sub |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet set to highlite a cell while data is being entered
Jacob's code works for me. Did you try the code I posted against your
response to Jacob elsewhere in this thread? -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... "Rick Rothstein" wrote: When I select a cell, it is automatically highlighted with a heavy border around it, so I'm guessing you have something else in mind... if you describe what it is, maybe we can help you out. Just so you know, whatever you describe for us will probably require VB code, so be prepared for that. -- Rick (MVP - Excel) "speerchucker30x378" wrote in message ... Can excel be set so that the active cell is highlighted while data is entered? . I have a simple invoice system that pretty much had to be custom made for an odd industry. Many of the cells are already surrounded by a border so when I select those cells to enter data into them the highlighted border virtually disappears. If I leave for a moment or two I have to re-select the cell as I can not see which one I have left open. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I line through data entered in an Excel worksheet without . | Excel Discussion (Misc queries) | |||
auto fill entered data from one worksheet to another | Excel Discussion (Misc queries) | |||
Highlite the cell if above 5:31 | Excel Worksheet Functions | |||
Select correct worksheet based on data entered into a cell | Excel Worksheet Functions | |||
eliminate data entered to a worksheet that copies to another work. | Excel Worksheet Functions |