-1

Just putting this out there to find out if anyone has a solution to this yet. When presenting my workbook on a projector, it is near impossible to read the drop down list. And the nifty combo box workaround is gone in excel 2016.

Anyone have any alternatives that are working for them?

Remi
  • 159
  • 3
  • 14
  • 1
    This is more a super user question I suspect. They will want to know what do you mean by" the nifty combobox workaround has gone" ? Comboboxes are still around in Excel 2016. Also, is it that the wording is too small or out of focus or both? – QHarr Mar 31 '18 at 06:06
  • @QHarr Apparently in Office 2013 and prior, you had the option to change font sizes in the combo boxes. That feature was removed in 2016. So now when you using a combo box to try and get around the data validation drop downs being too small to read, you have the same problem. – Remi Mar 31 '18 at 13:38
  • What office subscription are you using? And is this Mac or Windows? – QHarr Mar 31 '18 at 13:47
  • @QHarr Office 365 and Windows. – Remi Mar 31 '18 at 14:46

1 Answers1

1

In my edition of Office (MS Professional Plus 2016, Windows) I can do:

Option Explicit

Sub AddComboFont()

    Dim cb As ComboBox

    With ActiveSheet

        Set cb = .OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
                                 DisplayAsIcon:=False, Left:=322.5, Top:=11.5, Width:=176.5, Height:= _
                                 61.5).Object

        cb.Font.Size = 20

    End With

End Sub

Same thing can be achieved with right-click on combobox > properties > Font

This applies to ActiveX comboboxes. You can't change the Font size on the Form control combobox. This can be a trade off as Form control can be better behaved than ActiveX particularly when users have different screen resolutions. See my answer here Excel Comboboxes double up on some PCs

QHarr
  • 83,427
  • 12
  • 54
  • 101
  • I'm telling you that I can't do that on mine. For many other people, they can't do it either. How does your version have an option for font in the properties? – Remi Mar 31 '18 at 14:59
  • This is what I am trying to ascertain. Can you set the font with code? By referencing your combobox and then doing .Font.Size? – QHarr Mar 31 '18 at 15:00
  • I just tried using the code above and that also did nothing as well. Is there a way to add code to the combo box to change font? – Remi Mar 31 '18 at 15:11
  • Did you put it in a standard code module and run with a sheet selected? It should have added a combobox to that sheet or given you an error. Did nothing really happen? – QHarr Mar 31 '18 at 15:13
  • Got it running now. So this is an active x combo box correct? I still have to code in range and all that stuff? There is no control option when I look at properties is what I'm getting at. – Remi Mar 31 '18 at 15:26
  • 1
    You can’t change the font on a form control combo but should be able to on an ActiveX. You should be able to manually add an activex combobox and right click properties > font > set the font size you want – QHarr Mar 31 '18 at 15:28
  • you have helped greatly. Are there any caveats to this? My coworkers can use this with not problems like any other dropdown? – Remi Mar 31 '18 at 15:33
  • Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/167944/discussion-between-qharr-and-remi). – QHarr Mar 31 '18 at 15:46
  • I have added some info in chat – QHarr Mar 31 '18 at 15:53
  • I have a summary of the differences between the 2 types of controls (for example, a ***form control* combo box** and an ***ActiveX control* combo box**) as an [answer here](https://stackoverflow.com/a/49263001/8112776). – ashleedawg Apr 01 '18 at 13:33