Look at values in listbox not the number of items

Hi,

Please Login or Register  to view this content.

Regards

Hi,

I don't know what you mean. You asked what the value of list box 1 was. That's what the syntax I gave you does.

Regards

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I am sorry for not being clearer Richard. I am trying to sum the numbers in the ListBox. If the total sum is 1 then I want to display a message box. However if the total sum is greater than 1 then I want to call Macro 2. Can you help me?

Hi,

OK I'm guessing that your UserForm list box contains numbers in the first column, the BoundColumn property is set to 1 and the MultiSelect property is set to Multi so that you can pick various items from it. That wasn't obvious from your post.

In which case call the following procedure from a Command Button on your UserForm

Please Login or Register  to view this content.

Regards