• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

list box or combo box in excel

How do you implement a list box in excel?  Approximately 50 items?
0
brianpowell
Asked:
brianpowell
  • 3
  • 3
2 Solutions
 
Martin LissRetired ProgrammerCommented:
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
 
brianpowellAuthor Commented:
Sheet Use: Unless otherwise directed.

The list items will be pre-defined. Using MS access to identify the list items.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Martin LissRetired ProgrammerCommented:
See the 'Listbox Example' in this article.
0
 
brianpowellAuthor Commented:
thanks  for your time much appreciated!
0
 
brianpowellAuthor Commented:
251 = first responder : )
0
 
Martin LissRetired ProgrammerCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now