Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2014, 05:57 AM
Phil H Phil H is offline Increase Font Size in a List Box Windows XP Increase Font Size in a List Box Office 2003
Advanced Beginner
Increase Font Size in a List Box
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Increase Font Size in a List Box

Is there a way to increase font size in a List Box created in Data Validation?
Reply With Quote
  #2  
Old 12-09-2014, 07:18 AM
Phil H Phil H is offline Increase Font Size in a List Box Windows XP Increase Font Size in a List Box Office 2003
Advanced Beginner
Increase Font Size in a List Box
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Increase Font Size in a DV List Box

Understand from other forums, this cannot be done. A workaround is to zoom up the worksheet when any DV cell is selected. The following code (from Contextures http://www.contextures.com/xlDataVal08.html#Font ) works - it zooms up, then back down to whatever screen sizes are inserted in the code. The only issue is the selected cell needs to be placed center screen, and remain there after a selection is made from the dropdown list. Can someone modify this code to make that happen?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lZoom As Long
Dim lZoomDV As Long
Dim lDVType As Long
lZoom = 100
lZoomDV = 120
lDVType = 0

Application.EnableEvents = False
On Error Resume Next
lDVType = Target.Validation.Type

On Error GoTo errHandler
If lDVType <> 3 Then
With ActiveWindow
If .Zoom <> lZoom Then
.Zoom = lZoom
End If
End With
Else
With ActiveWindow
If .Zoom <> lZoomDV Then
.Zoom = lZoomDV
End If
End With
End If

exitHandler:
Application.EnableEvents = True
Exit Sub
errHandler:
GoTo exitHandler
End Sub
Reply With Quote
  #3  
Old 12-09-2014, 08:40 AM
Phil H Phil H is offline Increase Font Size in a List Box Windows XP Increase Font Size in a List Box Office 2003
Advanced Beginner
Increase Font Size in a List Box
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default The Best Solution

Here is the best solution - using a combo box (Again, from contextures http://www.contextures.com/xlDataVal14.html ). This approach puts a combo box (properties can be changed to suit) in any selected DV cell, and with additional code at the bottom, will dismiss the combo box when the next cell is selected. Remember to change the combobox name in the code.
Reply With Quote
Reply

Tags
font size, list box



Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase Font Size in a List Box increase the size of the insert hyperlink dialog box mswmacroman Word 3 02-16-2017 01:44 AM
Powerpoint 2007 mult-level list formatting (font size) angus.rouse PowerPoint 5 04-24-2014 05:49 AM
Increase Font Size in a List Box MAcro to List all the Font & its size in a word document shaukat74 Word VBA 1 01-29-2013 09:34 PM
from .doc to .rtf size increase X10 renato Word 1 05-15-2012 08:49 AM
Format Font Size in Combo Box List lukewarmbeer Word VBA 0 08-27-2011 07:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft