Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation - Excel 2007
Hi:
Can anyone tell me if there is a way to change the font size in a data validation drop down list in Excel 2007. Font is very small. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation - Excel 2007
On Feb 23, 4:10*pm, Theresa wrote:
Hi: Can anyone tell me if there is a way to change the font size in a data validation drop down list in Excel 2007. *Font is very small. Thanks, It is not possible. A very popular way to see the list better is to increase the zoom view when the data validation is selected, this is done with vba. If The Data Validation list is in A1 then this code will increase the zoom when A1 is selected. Right click on the sheet tab and select view code. Copy and Paste the code there Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveWindow.Zoom = 100 If Target.Address = "$A$1" Then ActiveWindow.Zoom = 200 End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Excel 2007 | Excel Worksheet Functions | |||
2007 Excel Data Validation | Excel Discussion (Misc queries) | |||
Data validation in Excel 2007 | Excel Discussion (Misc queries) | |||
Data validation in Excel 2007 | Excel Discussion (Misc queries) | |||
Data validation Excel 2007 | Excel Worksheet Functions |