Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption
Hello,
I have a workbook, see also my previous message, with labels on some sheets whose caption I'ld like to control with some udfs. I know that udfs don't allow to control the formatting or the values of a ws cell, but is this also true for the toolbox controls? In my case I have the label captions modified sometime yes and sometime not. Any tip? Emiliano |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption
You can change values of cells from a function. The main purpose of
functions is to seamlessly pass values from one sub to the next. -- Cheers, Ryan "eggpap" wrote: Hello, I have a workbook, see also my previous message, with labels on some sheets whose caption I'ld like to control with some udfs. I know that udfs don't allow to control the formatting or the values of a ws cell, but is this also true for the toolbox controls? In my case I have the label captions modified sometime yes and sometime not. Any tip? Emiliano |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption
Assuming that conditional formatting will not allow you enough ability to
change the format of the labels then you can use event code such as sheet change to format cells (or controls) as necessary. -- HTH... Jim Thomlinson "eggpap" wrote: Hello, I have a workbook, see also my previous message, with labels on some sheets whose caption I'ld like to control with some udfs. I know that udfs don't allow to control the formatting or the values of a ws cell, but is this also true for the toolbox controls? In my case I have the label captions modified sometime yes and sometime not. Any tip? Emiliano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
label caption | Excel Programming | |||
last cell as label caption | Excel Programming | |||
label caption | Excel Discussion (Misc queries) | |||
changing the caption of a label | Excel Programming | |||
label caption | Excel Programming |