List Box Record Count

M

Martin

Hello,

I am trying to calculate the number of records SELECTED in a list box on a
form and populate a text box on the same form with the results.

I have got this code that tells me the total number fo records but I just
want it for those selected. Does anyone know how to do this?

MsgBox ([ListBoxName].ListCount)

Many thanks in advance.

Martin
 
M

Martin

Thank you, much appreciated

Andrew Tapp said:
Martin

You could use Me!ListBoxName.ItemsSelected.Count

Hope this helps.

Martin said:
Hello,

I am trying to calculate the number of records SELECTED in a list box on a
form and populate a text box on the same form with the results.

I have got this code that tells me the total number fo records but I just
want it for those selected. Does anyone know how to do this?

MsgBox ([ListBoxName].ListCount)

Many thanks in advance.

Martin
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Copy previous record into form field 0
Creating a Search using a combo box and then creating a report. 4
list or combo box 0
Unable to display values in 2nd list box from 1st list box selection 2
Combo or list box 0
List Box with Record Count 4
WORD VBA Search and switch to advanced ... 1

Top