PDA

View Full Version : How to Modify Userform?



genracela
07-15-2010, 07:34 PM
I have a userform image attached, and I want to modify it.

1. How do I edit "USERFORM" to make it "Code Error"?

2. How will I change the font of "Please Change Search Option", to Bold and bigger size?

3. How Do I delete "Frame 1"?

Thanks in advance!

Aussiebear
07-15-2010, 11:13 PM
Hi genracela, could you have another go at posting the form please?

genracela
07-15-2010, 11:22 PM
Thank you aussiebear!

Here it is...

GTO
07-15-2010, 11:58 PM
1. How do I edit "USERFORM" to make it "Code Error"?

2. How will I change the font of "Please Change Search Option", to Bold and bigger size?

3. How Do I delete "Frame 1"?

1/2:
Read through vba help some for adding controls and such. See pic at bottom, you want yours to look the same. If the Properties window is missing, bring it to view as shown.

In the properties window, you can change the various available properties for a given control (or the userform itself), such as the font (bold/size) of what I presume is a label, or the Caption of the userform.

When in doubt at all, click on the property and F1 for context sensitive help about the property. Occassionally a property will show for a given control, wherein said property is not applicable.

3:
Again, presuming its a label, drag the label outside of the frame control, click on (select) the frame, press the Del key.

Hope that helps,

Mark

genracela
07-16-2010, 12:49 AM
Thanks Mark! I'll do that!

Mwahhhhhh!!!