Excel: user defined functions & formating

[Jonas Caspersson]

Hi, i have a Excel question.

Is it possible to from within a user defined function
(VBA) modify the cells properties, like .interior.color?

This would help since the function 'Conditional
formatting' is of no help for my specific demands.

What i want is to let the user select a function called
for instance 'FormatColor' from the insert function
dialog box, and then choose an refernence cell which
contains the formats he wants to use.

Exampel

within VBA module:

Function FormatCell (Ref as Range)
Application.ActiveCell.Interior.Color=Ref.Interior.Color
End Function

This does not work - I've tried... (
And by the way, Excel hangs!

Help, please

/Jonas Caspersson

 

[Randall Arnold]

I believe what you want is possible, but post your request in
microsoft.public.excel.programming to get the best response.

Randall Arnold

 

[Jonas Caspersson]

Thank's I'll try that..
/Jonas

-----Original Message-----
I believe what you want is possible, but post your request in
microsoft.public.excel.programming to get the best response.

Randall Arnold




.