Conversion hex/rgb automatic macro vba

[FRANZISS]

Hello,

I'm looking for a way to convert a colour value from hexa to rgb and vice versa in an excel macro.

I have already done a lot of research on google and generally I find excel formulas (use of boxes in the formulas to convert) instead of a VBA code. I'm not sure if it's a good idea to use a VBA code or not, but I'm not sure if it's a good idea to use a VBA code.

I'm looking for an automatic conversion, i.e. when the hex value is modified, the rgb value is updated and vice versa, all in the same table.

All this data is organized by columns and a third one is needed to display the corresponding colour.

So far I have fulfilled my specifications but it is not optimal, I have two tables. I'm calling for your help today to help me optimize my code

Tell me if it's not clear haha, I did the best I could. I am attaching the excel file as is.

Thanks in advance !

 

[AlanSidman]

crossposted: https://www.excelforum.com/excel-pr...rsion-hexadecimal-to-rgb-value-vba-macro.html

 

[Marc L]

Hello Franziss ! Read this !​

​

 

[FRANZISS]

I am sorry I didn´t know I will close this sry again !

 

[keebellah]

You don't have to close it but just like the warning you got here you got it at Excel help forum.
Correct and mention the cross post to be helped.
Here's what I wanted to post in Excel Help Forum

 

[keebellah]

Franziss: haven't you visited the forum yet?