Label caption

[eggpap]

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

 

[RyanH]

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.

 

[Jim Thomlinson]

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.