Macro-Drop Down Field

S

SherryJo

How can I get around the 25 entry limitation in a drop-
down field? Can I go get the list from another location
upon entry into the drop down field?
 
J

Jay Freedman

Hi, SherryJo,

That 25-item limit is hard-coded into the form-field dropdown. I don't know
why, or why that number, but there's nothing you can do about it. As soon as
you need more, you have to go with either the ActiveX combo box from the
Control Toolbox toolbar, or the dropdown in a userform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
MS Project Center-Autolink column fields 0
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Paragraph numbering in Word 1

Top