ExcelBanter - giving cells a nice color

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - giving cells a nice color (https://www.excelbanter.com/excel-programming/316600-giving-cells-nice-color.html)

Bart van den Burg

giving cells a nice color

Hi

how can I, in VBA, give a color to cells, text in cells, and make texts in
cells bold?

thanks

Bart van den Burg

giving cells a nice color

"Frank Kabel" schreef in bericht
...
Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold

what values are valid for colorindex?

Frank Kabel

giving cells a nice color

Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold

--
Regards
Frank Kabel
Frankfurt, Germany

"Bart van den Burg" schrieb im Newsbeitrag
...
Hi

how can I, in VBA, give a color to cells, text in cells, and make
texts in
cells bold?

thanks

Frank Kabel

giving cells a nice color

Hi
see:
http://www.mvps.org/dmcritchie/excel/colors.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Bart van den Burg" schrieb im Newsbeitrag
...

"Frank Kabel" schreef in bericht
...
Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold

what values are valid for colorindex?

Bart van den Burg

giving cells a nice color

"Frank Kabel" schreef in bericht
...
Hi
see:
http://www.mvps.org/dmcritchie/excel/colors.htm

Thanks a lot!

All times are GMT +1. The time now is 10:40 AM.