scrollbar lineweight and color combo box
hello !
i got a scrollbar(lineweight) and a combo box(color) but i woul need a help to change the chart line weight
scrollbar got
1- min (default)
2- medum
3- big
hope someone could help me !
because color doesnt got with lineweight together ...
example.xlsm
Last edited by ohboyherewegoagain; 01-15-2014 at 02:28 AM.
try something like this :
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
but i tried with scrollbar but it didnt change ... could you please correct it in workbook what i've provided as an example ?
and colors too doesnt work O_ OOriginally Posted by xlbiznes
click on the scroll bars to see the weight of the lines increase and decrease.
that did work ... but now i tried colors and it didnt change ... hmm....
maybe you can help me with multibox ? :O
Hello ohboyherewegoagain,
I made a few modifications to your workbook. The UserForm now uses the ComboBox to select the Chart Line. There are 10 buttons that are used to set the line color. These buttons have the same color as the cells in the "COLOR" range.
The user must select a chart line before the line size or color can be changed. If a changed is attempted without a line selected, a message tells the user to select a line.
Here is the code that has been added to the attached workbook.
ThisWorkbook
UserForm1Please Login or Register to view this content.
ColorButtons ClassPlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks! SOLVED !
ADDING!+ *
Hello ohboyherewegoagain,,
You're welcome. Glad I could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks