[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…
Suggested Courses

656 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