?
Solved

list box or combo box in excel

Posted on 2013-11-21
7
Medium Priority
?
487 Views
Last Modified: 2013-11-21
How do you implement a list box in excel?  Approximately 50 items?
0
Comment
Question by:brianpowell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
ozzeczek earned 753 total points
ID: 39665818
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 39665992
There are two types of controls that you can use in Excel, ActiveX and Forms. The former have more features and are easier to program, but they are designed for userforms and they are problematic when used on a sheet. Where will you be using the controls and what will be the source of their data?
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39666358
Sheet Use: Unless otherwise directed.

The list items will be pre-defined. Using MS access to identify the list items.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Assisted Solution

by:Martin Liss
Martin Liss earned 747 total points
ID: 39666460
See the 'Listbox Example' in this article.
0
 
LVL 1

Author Closing Comment

by:brianpowell
ID: 39666768
thanks  for your time much appreciated!
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39666770
251 = first responder : )
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 39666773
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question