Label Effects on userform

[asyamonique]

Is it possible to add special effect for the label at vba on the userform which will show the numbers like rainbow effects?

Me.Label12.Caption = Format(Sheets("LIST").Range("E1").Value, "###,##")

 

[Dan_W]

Not with a single label control, no. You could use an inkedit control to accomplish this though. See, for example, Thread 'Correct code for coloring a userform inkEdit textbox text string with the text string on multiple lines in the code' Correct code for coloring a userform inkEdit textbox text string with the text string on multiple lines in the code