ListBoxes 1

[gavjb]

Hi,

Does anyone know of an easy way in VBA to select all values in a multiselect(simple) listbox

Thanks,


Gavin,

 

[PHV]

Dim intRow As Integer
With Me![listbox name]
For intRow = 0 To .ListCount - 1
.Selected(intRow) = True
Next intRow
End with

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gavjb]

thanks, that worked perfectly