The question is very simply
I want to colorize the cells interior using a color present in theme colors dialog.
In this way the user can manipulate an excel workshet using the same color i an easiste way
oAs:Range( "A1:K1" ):Interior:Color:= RGB( 244, 176 , 132 )
in my opinion an expression like this does not set a color present in theme colors dialog
oAs:Range( "A1:K1" ):Interior:Color:= Interior:ColorIndex := 40
Bye to all
Marco
/*
1-Black; 2-White; 5-Blue; 41-Light Blue; 11-Dark Blue; 10-Green; 3-Red; 6-Yellow; 53-Brown; 13-Violet; 46-Orange; 7-Pink
*/
oSheet:Cells(1,2):Font:ColorIndex := 1
oSheet:Cells(2,2):Interior:ColorIndex := 5
/*
1-Preto ; 2-Branco ; 5-Azul ; 41-Azul Claro ; 11-Azul Escuro ; 10-Verde ; 3-Vermelho ; 6-Amarelo ; 53-Marron ; 13-Violeta ; 46-Laranja ; 7-Rosa
*/Use CHOOSECOLOR() function instead of a fixed RGB() color.
The Interior:ColorIndex return otrher colors different from that of theme colors dialog.have a look here https://learn.microsoft.com/en-us/office/vba/api/excel.colorindex
Is there a list of that colors?
Ok, I don't know, sotty. Try to ask the AI.
Why? You can write in Italian.
