how to use picture1.point?

Posted on 2002-05-16
Medium Priority
Last Modified: 2010-05-18
I'm using this:

MsgBox Picture1.Point(4, 4)

and I get a Long number:

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

Expert Comment

ID: 7015026

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


Accepted Solution

Crin earned 200 total points
ID: 7015031
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)

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))
End Sub
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.


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
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.

Expert Comment

ID: 7022221

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.

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

Expert Comment

ID: 7909695
per recommendation

Community Support Moderator @Experts Exchange

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question