Is it possible to have a UDF which will set the borders of a cell based
on its (or another cell's) value.
Conditional formatting is good but I am restricted to one line width.
Des


--
Des
------------------------------------------------------------------------
Des's Profile: http://www.msusenet.com/member.php?userid=690
View this thread: http://www.msusenet.com/t-1870083718

A function can only return a value -- doesn't matter if it is a
builtin function for Excel or VBA or if it is a UDF. A function
cannot change formatting of any cell, nor can it change the
value of another cell.

You would need a macro and more specifically, probably an
event macro. If the value of the cell being changed is by
changing it manually and not from a formula you would probably
want to use a a Change Event macro.
http://www.mvps.org/dmcritchie/excel/event.htm#change
Record a macro to get an idea of the code you need to use.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Des" wrote in message ...

Is it possible to have a UDF which will set the borders of a cell based
on its (or another cell's) value.
Conditional formatting is good but I am restricted to one line width.
Des


--
Des
------------------------------------------------------------------------
Des's Profile: http://www.msusenet.com/member.php?userid=690
View this thread: http://www.msusenet.com/t-1870083718