Format Cell (UDF)

P

Peter

Dear all,

I have a custom UDF and return an "object" (maybe DateTime type, String, Int
or Money), but the users can't format the cell with their corresponding
format by their own. However, they can format other cells on the same
worksheet (simple text).

Thanks,
Colt
 
C

Chip Pearson

The function itself cannot format the cell from which it was
called, but you can certainly apply formatting to the cell. What
happens when you try to format the calling cell?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top