Solved

# how to use picture1.point?

Posted on 2002-05-16
652 Views
I'm using this:

MsgBox Picture1.Point(4, 4)

and I get a Long number:
7745800

How can I get the Red,Green and Blue value?
0
Question by:wcoka

LVL 2

Expert Comment

ID: 7015026
Hi,

For Red: Value Mod 256
For Green: (Value \ 256) Mod 256
For Blue: (Value \ 65536) Mod 256

Sincerely,
Crin
0

LVL 2

Accepted Solution

Crin earned 50 total points
ID: 7015031
Hehe...
Actually, latest formula doesn't require mod operation...

so, it will look like
For Blue: Value \ 65536

(Where Value is a result of the Point function)

Sincerely,
Crin
0

LVL 22

Expert Comment

ID: 7015173
Or convert to hex first, then pull out the piece you need:

Private Sub Command1_Click()
Dim strPointColor As String
strPointColor = Format\$(Hex\$(Picture1.Point(4, 4)), "000000")

Debug.Print "Blue component is " & Val("&H" & Left\$(strPointColor, 2))
Debug.Print "Green component is " & Val("&H" & Mid\$(strPointColor, 3, 2))
Debug.Print "Red component is " & Val("&H" & Right\$(strPointColor, 2))
Debug.Print
End Sub
0

Author Comment

ID: 7015685
Hey guys, wich of thos two answers is faster? which way?

Also, what does that long number that comes from the point method means?

Thanks a lot
0

LVL 22

Expert Comment

ID: 7016660
Crin's is probably fasters since it doesn't convert back and forth between strings.

That long number is Window's way of keeping track of colors.  It actually represents the three components of a color monitor--Red, Green, and Blue pixels.  Since each can have a computer-defined range of 0 (off) to 255 (full intensity) they had the choice of forcing you to take the pixels individually to determine the color, or combine it; they chose to combine it.

For example, when you see yellow on the screen, your eye is actually tricked into it by seeing bright red combined with bright green.

That long number is actually the computer storing the pixel values in three consecutive bytes which, when interpreted in decimal, looks like a long number that you see.  When interpreted in hexadecimal, it becomes much clearer what each component represents.  Both examples above take different approaches to interpreting the number's 3 bytes.
0

LVL 2

Expert Comment

ID: 7022221
Hi.

rspahitz's answer regarding long number is almost right.

Actually, *four* bytes used to store each pixel colour: three to store each channel intensity and one to define custom colors.

For example, there are system values for following colors: scroll bars, desctop, active title bar, inactive title bar etc. And you can use these settings to specify form background color.

So, if you get long number that represents color:
00 xx yy zz (smallest goes last) - 00 means that it is custom color, xx - blue component value, yy - green component value, and zz - red component value.
80 (hexadecimal value) in place of 00 will mean that system will fill form or any other control to specified system color.

Also, my way will work faster since string operations are most time consuming in VB for simplest data types.

Sincerely,
Crin.
0

LVL 49

Expert Comment

ID: 7817744
Hi wcoka,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

Accept Crin's comment(s) as an answer.

wcoka, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0

Expert Comment

ID: 7909695
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…