Results for "automatic hex rgb conversion vba macro"

Hi ! Lisa Nguyen,

Here, your Excel File is back, with automatic conversion.

If you agree, you can display the corresponding color with your VBA Module3. Sub RGB_TO_HEX_COLOR()

See my Note in Sheet1.

Breaking News,

Excel File Version2 is coming Now.

Best Regards.

Good evening Lisa,

I propose you here a fully automated version of the macro, meaning that :

When you modify the hexa color, it will both change the RGB values accordingly and change the color of the colored cell automatically too.

When you modify one of the RGB value, it will both change the Hexadecimal value accordingly and change the color of the colored cell automatically too.

No need for any button to apply the tranformations.

Wow really thanks for what you did! I saw the message you left on the excel file!

I will now try to analyze and understand what you have written in the code.

Thank you again and if you manage to switch from RGB to HEX it would be amazing !

Hello,

For my internship, I have to create an excel macro to convert a color value in hexa code to rgb and vice versa.

I have already done a lot of research on google and in general I find excel formulas (use of boxes in the formulas to convert) instead of a VBA code. In addition, it takes usually 2 tables, one from hex to rgb and another from rgb to hex.

But I'm looking for an automatic conversion, that is to say to make a modification of the hex value, the rgb value is updated and vice versa, all in the same table.

All these data are organized by columns and you need a third one to display the corresponding color.

For the moment I have fulfilled my specifications but it is not optimal, I have indeed two tables. I call for your help today to help me to optimize my code.

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

Thanks in advance !

Re,

A Power Query proposal to study.

Regards.

Hello,

Understand you cannot attach your workbook ... for confidential reasons ...

However, the one thing you could do is insert the code you have created ...

It might be that ... just by looking at your macro ... a solution might pop up ....

Hello and welcome,

try this, select the data and execute this macro.

Sub createcolumnchartwithselection()

    Set ch = ActiveSheet.Shapes.AddChart2(366, xlColumnClustered)
    ActiveSheet.ChartObjects(ch.Name).Activate
    ActiveChart.ChartArea.Select
    ActiveChart.ChartStyle = 201
End Sub

Hi there, i am new to vb excel and i need help.

What would be the macro for making excel create time series chart if two columns are selected where the left column is dates and right column is data

Jean-Eric

I love you, I love you, I love you...

Thank very much.

Much thanks to you and your patience, working with me especially with my English language.

You should become my excel teacher.

Greatly appreciated

Thank you again. God Bless You.

Hello Jean-Eric,

Thank you for your swift response.

Please view the sample file below.

Please note: the raw data is on cell "A1" and

The extracted data example is on cell "N" and cell "O"

There are many excel workbook I need to extract data.

How can I create a universal code to extract each one.

Thanks in advance. Greatly appreciated.

Hello,

Please attach a small file at your request.

Regards

Hello Fans.

Currently I have Many Raw Data as an example below to section out.

What's beautiful, all the following data are similar:

Here is an example in row "1", in column "A" only :

0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …}

In this Case: How can I Keep the values of The following:

9 1997-03-01

I have multiple data similar like above. The comparison with the others are, values and dates.

What is the effective way to get the data?

Or what code can I use? How do you want me to proceed?

Thanks in advance

Hello,

When it comes to these kinds of errors ... you do have to make sure your spelling of your various folders' names is 100% correct ...

Hope this will help

[Good morning

it's very helpful, but i always get an error on this line:

Set Folder = OutlookNamespace.GetDefaultFolder(olFolderInbox).Folders("Net Sales Report").Folders("Sales")

eventhought i have created two folders in my inbox with the same name.

Hello again,

Below is a link which provides you with the operational answer to your initial question ...

https://www.howtoexcel.org/vba/how-to-import-your-outlook-emails-into-excel-with-vba/

Hope this will help you solve your problem ...

hello

thank you for your help after a deep search unfortuntly i couldn't find what i'm looking for

Hi,

The best available resource is Ron de Bruin' s site ...

https://www.rondebruin.nl/win/s1/outlook/mail.htm

You will find there all kinds of ready made solutions for Outlook ...

Hope this will help

I'm looking to create a simple outlook macro that would export emails in a specific folder into an excel worksheet. The folder can be called "test" for reference purposes and the excel spreadsheet can be anything.

Outlook will always remain open and the spreadsheet would not be located on a server. This is all local.

Information I would like coming over is the date and the body (possibly the subject).

I've tried this a few different times and have yet to get a working version. I'm using Office 2016.

Any help would be greatly appreciated (appreciated = paypal???)

You all are great and very kind for helping out. It is greatly appreciated.

Jean-Eric a écrit :

Hello,

can you send us a file ?

We need additional information to help you.

Many thanks for your response!

Here you can see the file, the macro which is the last and the most successful is named "Macro".

The first Worksheet is the data extract that I have and second one is the one where I created the macro.

Waiting for your reply, nd thanks again. Please, let me know if you have any other questions.