Macro to permently change backcolor on a userform

I am trying to change the color on a userform through a macro. I can not simply change in properties becouse the change will be dictated by clicks from the user. Currently what I have changes when ever a macro outside of this userform runs.

[Sub b_Click()

B.backcolor = vbred

End sub()]

Remove any ends from rest of mudule

You could have a named range in your workbook, perhaps on a hidden sheet, called Background. The value in that range can be changed as required, then in the Initialize event of the form use:

Please Login or Register  to view this content.