Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel stuff
Message
From
22/06/1999 16:56:36
 
 
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00231352
Message ID:
00232725
Views:
26
>>>I would like to format an excel row based on the contents of a cell in that row. eg if cells in col 6 = passed I want the row to be green. I have made the cell green but not the row. :( Can excel do that? What would be the best tool for this? A VBA addin or just plain ol Excel?
>>>
>>>Thank you all so much,
>>
>>
>>Try this:
>>
>> Columns("D:D").Select
>> With Selection.Interior
>> .ColorIndex = 4
>> .Pattern = xlSolid
>> End With
>
>Not to sound like a total idiot but where would I put that? Is this a VBA script? or in a cell?


My fault !
I should have pointed out that this code was generated with the Excel macro recorder so yes, it's VBA code.

Now, how to apply this to an Excel object that you are creating in VB ?
Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform