Solved

Count items in userform listbox excel vb

Posted on 2009-04-02
3
1,031 Views
Last Modified: 2013-12-26
Is there a way to count how many items are in a listbox in an excel userform? Thanks
0
Comment
Question by:tchristie33
  • 2
3 Comments
 
LVL 4

Expert Comment

by:Avelan
ID: 24053196
Hey,

try listbox.items.count

-Avelan
0
 

Author Comment

by:tchristie33
ID: 24053224
.items is not a found method or data member.
0
 
LVL 4

Accepted Solution

by:
Avelan earned 500 total points
ID: 24053320
Hrm, how about listbox.listcount then?

-Avelan
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 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