change Excel Cell forecolor using VB6
 

Hi there,

I am exporting data from ACCESS database to EXCEL Spreadsheet. If the Sales
value is below certain value, I like to forecolor for a specific row to be
RED in color.

Tried using this code in VB6 and it's not working:
objWorksheet.Cells(intRow, intCol).Fill.SchemeColor = vbcolor

change Excel Cell forecolor using VB6
 

objWorksheet.Cells(intRow, intCol).Interior.ColorIndex = 5

change Excel Cell forecolor using VB6
 

I wonder if you might need to use the RGB Color scheme.
--
HTH,
Barb Reinhardt



"Lennie" wrote:

Hi there,

I am exporting data from ACCESS database to EXCEL Spreadsheet. If the Sales
value is below certain value, I like to forecolor for a specific row to be
RED in color.

Tried using this code in VB6 and it's not working:
objWorksheet.Cells(intRow, intCol).Fill.SchemeColor = vbcolor