-User Forms-

Mar 8th, 2002, 07:50 AM

I have designed a user form (as a module),
Is there a way I change the background colour and text colour?

Mudface · Mar 8th, 2002, 07:58 AM

If you mean you've designed it by inserting a userform, right-click on it, select properties and change the back and fore colors colours that way.

If you've created it 'on-the-fly', then use the following to change the colours: -

UserForm1.BackColor = vbRed
UserForm1.ForeColor = vbBlue

(for example).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 07:50 AM	#1
Guest Posts: n/a	I have designed a user form (as a module), Is there a way I change the background colour and text colour?

Mar 8th, 2002, 07:58 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If you mean you've designed it by inserting a userform, right-click on it, select properties and change the back and fore colors colours that way. If you've created it 'on-the-fly', then use the following to change the colours: - UserForm1.BackColor = vbRed UserForm1.ForeColor = vbBlue (for example).