?
Solved

select list box

Posted on 1998-08-30
3
Medium Priority
?
146 Views
Last Modified: 2010-04-30
i would like to know how to make a button that when pressed it would select all the contents of a list box and press another button to deselect all the contents of the same list box
0
Comment
Question by:440
  • 3
3 Comments
 
LVL 3

Accepted Solution

by:
a111a111a111 earned 200 total points
ID: 1431974
Option Explicit

Private Sub Command1_Click()
Dim A%
For A = 0 To 3
 List1.Selected(A) = True
 Next A
End Sub

Private Sub Command2_Click()
Dim A%
For A = 0 To 3
 List1.Selected(A) = False
 Next A

End Sub

Private Sub Form_Load()
Dim Entry
        List1.Clear
        Entry = "Hello"
        List1.AddItem Entry ' Add the entry.
        Entry = "Bill"
        List1.AddItem Entry
        Entry = "This Is"
        List1.AddItem Entry
        Entry = "a Test"
        List1.AddItem Entry

End Sub

0
 
LVL 3

Expert Comment

by:a111a111a111
ID: 1431975
Hi,
if you need more assistent let me know.

Thank you.

0
 
LVL 3

Expert Comment

by:a111a111a111
ID: 1431976
The key is:

List1.Selected(A) = True

and

List1.Selected(A) = False

Shay.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

590 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