Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-17-2014, 11:30 PM
excelledsoftware excelledsoftware is offline RGB color codes? Windows 7 64bit RGB color codes? Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

So are you looking to do this in VBA? if so you need to put some more code in so that your program know what objects to look at. Start with this

Code:
If Range("A1").Interior.ColorIndex = 4 Then
  If Range("A1").value <> "" Then
    msgbox "This cell equals nothing and is green."
  End If
End If
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
RGB color codes? Color codes as background Anderso Excel 1 12-19-2014 11:53 PM
Converting color codes in VBA Ulodesk Word VBA 7 11-24-2014 04:15 AM
Is it possible to merge the two VBA codes into just one sam2149 Excel Programming 0 02-26-2014 05:28 AM
RGB color codes? I created a custom XML color scheme. How do I add that to the Built-in Color? Cassik PowerPoint 5 11-04-2013 02:08 PM
RGB color codes? Codes for Word Textbox Font Color? tinfanide Word VBA 7 10-23-2012 03:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft