Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CHANGING FONT SIZE
I have a list in excel that needs to be printed within a certain space
variable data. Is there a way to set up a formula/macro that will change the font size if there are more than say 60 characters but leave any less than 60 characters the same size. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CHANGING FONT SIZE
Formulas can't change formatting such as font size.
One possibility: Put this in the ThisWorkbook code module: Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1").Range("A1") If Len(.Text) 60 Then .Font.Size = 8 End With End Sub Change your worksheet and cell to change. In article , gwbdirect wrote: I have a list in excel that needs to be printed within a certain space variable data. Is there a way to set up a formula/macro that will change the font size if there are more than say 60 characters but leave any less than 60 characters the same size. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CHANGING FONT SIZE
Hi JE,\
I put the code in the THISWORKBOOK MODULE. hOW DO i MAKE IT RUN. Do I need to set up a button. "JE McGimpsey" wrote: Formulas can't change formatting such as font size. One possibility: Put this in the ThisWorkbook code module: Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1").Range("A1") If Len(.Text) 60 Then .Font.Size = 8 End With End Sub Change your worksheet and cell to change. In article , gwbdirect wrote: I have a list in excel that needs to be printed within a certain space variable data. Is there a way to set up a formula/macro that will change the font size if there are more than say 60 characters but leave any less than 60 characters the same size. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
CHANGING FONT SIZE
You don't need to do anything special--except allow macros when you open the
workbook. The workbook_beforeprint will fire each time you use print or print preview. gwbdirect wrote: Hi JE,\ I put the code in the THISWORKBOOK MODULE. hOW DO i MAKE IT RUN. Do I need to set up a button. "JE McGimpsey" wrote: Formulas can't change formatting such as font size. One possibility: Put this in the ThisWorkbook code module: Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1").Range("A1") If Len(.Text) 60 Then .Font.Size = 8 End With End Sub Change your worksheet and cell to change. In article , gwbdirect wrote: I have a list in excel that needs to be printed within a certain space variable data. Is there a way to set up a formula/macro that will change the font size if there are more than say 60 characters but leave any less than 60 characters the same size. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing the font size in the charts | Excel Programming | |||
Changing the font case size across a worksheet | Excel Discussion (Misc queries) | |||
automatically changing font size | Excel Programming | |||
Changing font size in a list box | Excel Discussion (Misc queries) |