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

Filling a list box using a range

Folks,
In the attached workbook in the Menu tab I have a lit box under Category. Filling this list box uses a Range from the Topics worksheet (AZ). The list box also populates the text box next to it. My problem is that I can only list 10 categories although I have more. I have not figured out what is wrong on why I cannot add more that 10 categories?
Charting-Data-in-Excel-2010-Revi.xlsm
0
Frank Freese
Asked:
Frank Freese
  • 2
  • 2
1 Solution
 
MacroShadowCommented:
I see 14 (Column, Cylinder, Cone, Pyramid, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar)
0
 
Frank FreeseAuthor Commented:
Do they appear in the list box?
0
 
Frank FreeseAuthor Commented:
thank you - I see them now also.
0
 
MacroShadowCommented:
Yes.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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