quote:
Originally posted by mwe99
It still makes the code red
i don't know why but its not seeming to accept the code so i deleted the code
We said to disregard Blade's code as that isn't even logical programming code and will never work in any programming language.
quote:
Originally posted by mwe99
i attached this to see if anyone can see the solution.
1) The code you're working in is "VB
A" (aka "Visual Basic
for Applications"). This is not the same as "Visual Basic" which we were all talking about (although many things are similar)!
2) Look at my code which I attached in the zipfile in my previous post and the related comments... The thing you need to change is to add the code for the colorbutton to each individual color button on your form, as VBA doesn't support array's of controls, the rest of the principle is just the same.
EDIT: I've edited your Excel sheet with working code for that particular form (see attachment in this post).
/ 
Attachment: 
