|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2008, 07:10 PM
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
September 22nd, 2008, 07:43 PM
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
September 22nd, 2008, 09:14 PM
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
September 22nd, 2008, 09:47 PM
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)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
