change font size in excel vba
 

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

change font size in excel vba
 

I have a small form to input data

Hi Pierre

Userform ?
Sheet ?



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pierre" wrote in message ...
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

change font size in excel vba
 

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 ...
I have a small form to input data

Hi Pierre

Userform ?
Sheet ?



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pierre" wrote in message
...
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

change font size in excel vba
 

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.

change font size in excel vba
 

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

pierre

a écrit dans le message
. com...


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.