Label caption

E

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
 
R

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top