?
Solved

Hex Codes for the standard Excel Pallete

Posted on 2006-05-10
7
Medium Priority
?
475 Views
Last Modified: 2008-01-09
Does anyone know of a reference that gives the hex codes I can use in visual basic for the standard colour pallete in excel.  The pallete used in visual basic is different from that used in excel and i need the identical colours.  I am most interested in the pastel colours along the bottom row of the excel pallete.

I need these now hence the high points!!!

Thanks in advance

Sy
0
Comment
Question by:sydodman
  • 4
  • 3
7 Comments
 
LVL 14

Expert Comment

by:nltech
ID: 16647152
excel 2k3: bottom row, left to right:
pink #ff99cc, orange #ffcc99, yellow #ffff99, green #ccffcc, lite blue #ccffff, blue #99ccff, purple #cc99ff
0
 

Author Comment

by:sydodman
ID: 16647171
I found the same codes earlier but they dont work in visual basic.  For example...

msflexgrid.cellbackcolor = #ffff99

returns "Compile Error - Syntax Error"

Replacing the # with an & which all other hexcodes in vb use also does not work

Sorry
0
 
LVL 14

Expert Comment

by:nltech
ID: 16647203
can you use rgb?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 14

Expert Comment

by:nltech
ID: 16647222
it's been awhile, but ain't colors in vb &Hbbggrr ?
0
 

Author Comment

by:sydodman
ID: 16647266
I can use RGB but I still need to know the values
0
 
LVL 14

Accepted Solution

by:
nltech earned 2000 total points
ID: 16647282
>> msflexgrid.cellbackcolor = #ffff99

>>returns "Compile Error - Syntax Error"

shouldn't the color here be &H99FFFF ?


convert html colors to vb colors
http://www.vb-helper.com/howto_vb_html_colors.html
0
 

Author Comment

by:sydodman
ID: 16647320
OK I get it,

I just have to reverse the rrggbb to bbggrr

Thanks for all your help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
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.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

864 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