Increase list source in Data Validation

Asked

Viewed 7,859 times

3

Hello, I have a field of my spreadsheet that has a list by data validation, I would like to know how to increase this source, leaving it more visible.

NOTE: Without the zoom scheme.

That is the list:

inserir a descrição da imagem aqui

excel vba

  • I was posting a reply when updated... no zoom I find difficult. Unless you use a combobox

  • I forgot to add excuse, how would it be with combobox?

  • 1

    Zoom - http://www.contextures.com/xlDataVal08.html#Larger Combobox, something like this: With Worksheets("Sheet1").OLEObjects("ComboBox1")
 .Object.Font.Size = 16
End With

  • 1

    Here is a complete template: http://www.contextures.com/xlDataVal10.html

1 answer

2

Leandro unfortunately, you cannot change the font size or style in a drop-down list created using data validation.

You can style the text in a combo box, however you can use an Activex control combo box by changing the properties 'Font' and 'Listfillrange' you will achieve the desired.

inserir a descrição da imagem aqui

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.