Converting color codes in VBA

		Microsoft Office Forums > Microsoft Word > Word VBA
Converting color codes in VBA

10-29-2013, 10:06 PM

macropod

Windows 7 32bit Converting color codes in VBA

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Ulodesk,

Is there a reason you can't work with the RGB values directly? For example:

Code:

Sub Demo()
Selection.Cells(1).Shading.BackgroundPatternColor = RGB(225, 225, 225)
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Codes Popping Up In My Text?	Faedrie	Word	1	11-08-2012 01:00 AM
Codes for Word Textbox Font Color?	tinfanide	Word VBA	7	10-23-2012 03:13 PM
Losing VBA codes in .dotm	tinfanide	Word VBA	15	04-12-2012 12:39 AM
Outline Codes	eliz.bell	Word	4	03-28-2012 07:27 PM
Why run-time is always different from stepping into the codes?	tinfanide	Excel Programming	1	03-04-2012 12:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 PM.