Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change default font type/size in excel? | Setting up and Configuration of Excel | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
How can I change the font size on an Excel sheet tab? | Excel Discussion (Misc queries) | |||
Change default font and size in Comments box in Excel. | Setting up and Configuration of Excel | |||
Change Font size in Excel VBA | Excel Programming |