change font size in excel vba

[Pierre]

Hi all,

I have a small form to input data

It would be nice if i can make the font bigger to ease data entry

There are no font size property.

How can i change the font size on the form only

best regards,
Pierre

 

[Ron de Bruin]

I have a small form to input data

Hi Pierre

Userform ?
Sheet ?

 

[Pierre]

Hi,

I do not understand your ?

I have a macro in vba in an excel sheet
The macro open a form
The user type in data that is validated againt a lookup table.
When data is ok, a new line is appended in the excel sheet.

that's it.

Now i just want to change the font on the form.
Now i have a something like Arial 12

I would like arial 24.

How can i do that?

regards,

Ron de Bruin a écrit dans le message ...

 

[avpendse]

Can use "FormName".Font.Size = "Desired font size" through code or
directly set the Font (Type and Size) Property of the form in the
design view.

 

[Pierre]

thanks,
i just notice that if i clik on the fontname in the form properties i can
change the size!
regards,

pierre

(e-mail address removed) a écrit dans le message