| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight selecting
Hi all.
I'm looking to find out what the colored "boxes" are called when we enter a worksheet function, and select either a single cell, or a range of cells. I have a user form that I've created, and I need to have something like the colored boxes to "outline" the ranges I've chosen as I work through the elements of my form. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight selecting
On Sep 22, 1:10 pm, SteveDB1
wrote: Hi all. I'm looking to find out what the colored "boxes" are called when we enter a worksheet function, and select either a single cell, or a range of cells. I have a user form that I've created, and I need to have something like the colored boxes to "outline" the ranges I've chosen as I work through the elements of my form. Thank you. Help calls them "color-coded border". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight selecting
Spiky,
Thanks for the response. The closest that I can find is called- vbActiveBorder But they are calling it- Border color of active window. what parameters did you use to find your answer? When I typed in what you came up with I got just about every response you could imagine, but not the one you're saying. Thank you for your assistance. Best, SteveB. "Spiky" wrote: On Sep 22, 1:10 pm, SteveDB1 wrote: Hi all. I'm looking to find out what the colored "boxes" are called when we enter a worksheet function, and select either a single cell, or a range of cells. I have a user form that I've created, and I need to have something like the colored boxes to "outline" the ranges I've chosen as I work through the elements of my form. Thank you. Help calls them "color-coded border". |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight selecting
On Sep 22, 3:14 pm, SteveDB1
wrote: Spiky, Thanks for the response. The closest that I can find is called- vbActiveBorder But they are calling it- Border color of active window. what parameters did you use to find your answer? When I typed in what you came up with I got just about every response you could imagine, but not the one you're saying. Thank you for your assistance. Best, SteveB. I think using both "color" and "formula" gave the result. The Help page title is "Change which cells a formula refers to". That's the only ref I found to these particular colors in Help. (xl2003) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007- when selecting a range to edit, it has no highlight | Excel Discussion (Misc queries) | |||
| i want to highlight entire row when selecting a cell in that row | Excel Discussion (Misc queries) | |||
| When selecting cells in Excel 07 why doesn't it highlight? | Excel Discussion (Misc queries) | |||
| how to darken the color of highlight when selecting a row in xcel | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
