Hi guys,
Was kinda wondering if this is possible. I have some charts in my workbook, I would like to create a command button that would select a chart, then loop through the legend names, displaying them in a listbox in the userform, and then allowing the user to multi select the legends in the listbox, and then select the color for the selected legends.
I did some search in google for the color option control, but from what I found was the common dialog control is not available for VBA, I'm not sure whether the Application.Dialogs(xlDialogColorPalette).Show function would help in this case. Pardon me for I'm still a novice in this. Please lend me some helping hand in this, kinda stucked.
Help will be very much appreciated,
CJ
Was kinda wondering if this is possible. I have some charts in my workbook, I would like to create a command button that would select a chart, then loop through the legend names, displaying them in a listbox in the userform, and then allowing the user to multi select the legends in the listbox, and then select the color for the selected legends.
I did some search in google for the color option control, but from what I found was the common dialog control is not available for VBA, I'm not sure whether the Application.Dialogs(xlDialogColorPalette).Show function would help in this case. Pardon me for I'm still a novice in this. Please lend me some helping hand in this, kinda stucked.
Help will be very much appreciated,
CJ
