| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Whole List or Items in List Box
Hi all, I need macro on a button which can select all the items or
list in ListBox1. Please can any friend can help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Whole List or Items in List Box
Dim i As Long
With Me.ListBox1 .MultiSelect = fmMultiSelectExtended For i = 1 To .ListCount .Selected(i - 1) = True Next i End With -- __________________________________ HTH Bob "K" wrote in message ... Hi all, I need macro on a button which can select all the items or list in ListBox1. Please can any friend can help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Whole List or Items in List Box
On Feb 18, 10:32*am, "Bob Phillips" wrote:
Dim i As Long * * With Me.ListBox1 * * * * .MultiSelect = fmMultiSelectExtended * * * * For i = 1 To .ListCount * * * * * * .Selected(i - 1) = True * * * * Next i * * End With -- __________________________________ HTH Bob "K" wrote in message ... Hi all, *I need macro on a button which can select all the items or list in ListBox1. *Please can any friend can help.- Hide quoted text - - Show quoted text - Thanks lot Bob. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Whole List or Items in List Box
On Feb 18, 10:32*am, "Bob Phillips" wrote:
Dim i As Long * * With Me.ListBox1 * * * * .MultiSelect = fmMultiSelectExtended * * * * For i = 1 To .ListCount * * * * * * .Selected(i - 1) = True * * * * Next i * * End With -- __________________________________ HTH Bob "K" wrote in message ... Hi all, *I need macro on a button which can select all the items or list in ListBox1. *Please can any friend can help.- Hide quoted text - - Show quoted text - Bob do you know that what sort of adjusment I should make in your macro if I want to select all the items or list in ListBox1 except the last item |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Whole List or Items in List Box
"K" wrote in message ... On Feb 18, 10:32 am, "Bob Phillips" wrote: Dim i As Long With Me.ListBox1 .MultiSelect = fmMultiSelectExtended For i = 1 To .ListCount .Selected(i - 1) = True Next i End With -- __________________________________ HTH Bob "K" wrote in message ... Hi all, I need macro on a button which can select all the items or list in ListBox1. Please can any friend can help.- Hide quoted text - - Show quoted text - Bob do you know that what sort of adjusment I should make in your macro if I want to select all the items or list in ListBox1 except the last item For i = 1 To .ListCount - 1 HTH. Best wishes Harald |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Whole List or Items in List Box
On Feb 18, 2:18*pm, "Harald Staff" wrote:
"K" wrote in message ... On Feb 18, 10:32 am, "Bob Phillips" wrote: Dim i As Long With Me.ListBox1 .MultiSelect = fmMultiSelectExtended For i = 1 To .ListCount .Selected(i - 1) = True Next i End With -- __________________________________ HTH Bob "K" wrote in message .... Hi all, I need macro on a button which can select all the items or list in ListBox1. Please can any friend can help.- Hide quoted text - - Show quoted text - Bob do you know that what sort of adjusment I should make in your macro if I want to select all the items or list in ListBox1 except the last item For i = 1 To .ListCount - 1 HTH. Best wishes Harald- Hide quoted text - - Show quoted text - thanks Harald |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List - Select Multiple Items | Excel Worksheet Functions | |||
| Can I create a dropdown list to select multiple items | Excel Worksheet Functions | |||
| Hi-lighting items in a multi-select List box | Excel Programming | |||
| select multiple items from a dropdown list | Excel Worksheet Functions | |||
| Create a macro to select items from an existing list .... | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
