Colour lines
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Assaf,
Visual Basic is beyond my capabilities unfortunately.
I’m not even 100% sure you’ll be able to change the cell colour using VBA, but that is the only option if you’re using 2k3.
Regards,
Darren
Can you tell me what is the command in VBA?
Hi Assaf,
I don’t think it is possible to colour a cell in 2k3 without VBA. In 2k7 you can change background colours by right-clicking in the cell, choose font and then the background colour / pattern.
Regards,
Darren