From Color to Hex

[Tristan]

Is there any way that I can get the hex value of a color then pass it
into a string?

[Terry Ford]

Post by Tristan
Is there any way that I can get the hex value of a color then pass
it into a string?

The easiest way I know is to use a Variant to convert it for you.


Dim s As String
Dim c As Color=&cFF00FF
Dim v As Variant
v=c
s=v

s should now contain "&hFF00FF"

Terry

[Carlos M]

Post by Terry Ford

Post by Tristan
Is there any way that I can get the hex value of a color then pass
it into a string?

The easiest way I know is to use a Variant to convert it for you.
Dim s As String
Dim c As Color=&cFF00FF
Dim v As Variant
v=c
s=v
s should now contain "&hFF00FF"

Or just using CStr:
Dim s As String
Dim c As Color=&cFF00FF
s = CStr(c)

Carlos

[Tristan]

Thank you all. Will use Cstr.

Post by Terry Ford

Post by Terry Ford

Post by Tristan
Is there any way that I can get the hex value of a color then pass
it into a string?

The easiest way I know is to use a Variant to convert it for you.
Dim s As String
Dim c As Color=&cFF00FF
Dim v As Variant
v=c
s=v
s should now contain "&hFF00FF"

Dim s As String
Dim c As Color=&cFF00FF
s = CStr(c)
Carlos
_______________________________________________
<http://www.realsoftware.com/support/listmanager/>
<http://support.realsoftware.com/listarchives/lists.html>