User Defined Formular

  • Thread starter Thread starter Eileen
  • Start date Start date
E

Eileen

I have two user defined formular trying to get the value
of the color font & interior. I saved as "add-in" and
activate from Tool-add in. The problem I have is it is
not refreshing! No matter what color font, I got the
value -4105; no matter what color interior, I got the
value -4142. PLEASE HELP and I really appreciate it.


Function colorfont(MyColor As Range) As String
colorfont = MyColor.Font.ColorIndex ' Get value of font
color
End Function

Function ColorInterior(MyColor As Range) As String
ColorInterior = MyColor.Interior.ColorIndex ' Get value
of interior Color
End Function
 
Hi!

Thanks, Earl. Well said.

The use of incidentals like colour of cell or "is it *Bold*" leaves m
anxious if not cold. I'm more comfortable with causes rather tha
symptoms.

Al
 
You must log in or register to reply here.

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

Similar Threads

Help using Chip Pearsons code to count cells with color 9
Excel VBA 1
sum colored cells 4
Assigning a Variable to an Expression that Includes a Variable andVBA Property 3
ColorIndex Sub-Routine not working as expected 2
Q: UDF with Interior.colorindex Help needed 4
Help with macro looping and color query function 10
count cells with diagonal borders 3

Back
Top