Color command button font

**jomili** · 06-06-2012, 03:07 PM

The code below was created to be used in Excel 2003, and worked fine to create two command buttons, one to cancel the automation, one to resume it. Now I'm on 2010, and when I run it I get an error code saying the font size has to be between 1 and 409 points. However, the highlighted code is the

Please Login or Register  to view this content.

I'd appreciate some direction in how to revamp just that part of the code. The rest of the functionality still works great. Full code is pasted below. Thanks in advance.

Please Login or Register  to view this content.

**snb** · 06-07-2012, 03:52 AM

I had no problems in E 2010 using:

Please Login or Register  to view this content.

**jomili** · 06-07-2012, 08:50 AM

And I had no problem using your code, either. Neat the way you worked it out; where I was working on the first part of the font on one button, then the middle part, then the ending part, your code colors all the font, then recolors the middle ("Resume" or "Cancel"), then creates the next button when J changes to 2, so it's all the same code, instead of different code for each button. Cool! Definitely more elegant, but if "Resume" and "Cancel" (both 6 characters long) were to be replaced with "Stop" and "Start" (4 and 5 characters) you'd have to step out the code more like my original code, wouldn't you?

I still don't understand why my original code was producing an error. Can you advise on that, just to help with my understanding?

Thanks,
John

**snb** · 06-07-2012, 09:08 AM

Only a slight modification though:

Please Login or Register  to view this content.

I still don't understand why my original code was producing an error

I 'aven't got the faintest....
But avoiding 'select' and activate is always recommendable.
And I left out defaultvalues.

**jomili** · 06-07-2012, 10:16 AM

I don't think "recommendable" is a word, but it certainly fits. On your altered code below:

Please Login or Register  to view this content.

I understand what you're doing; if J is 1, then at the 15th character, for the next 6, color it red. If J is 2, then at the 15th character, for the next 5, color it red. I like the way you did that, and didn't see that type of solution myself. I think with that example I can use this routine in a few different applications. Thanks for showing me how.