List Box Value Problem

[tradinup2]

Hi folks,

I'm not picking up the value as I cycle thru a List box.
Here's the code.

Please Login or Register  to view this content.

The list box is bound to column 4 where the total resides, but I'm getting a Null for the value.
After the sub runs I can do this:

Please Login or Register  to view this content.

Here I get the value expected.

How did I mess this up?

thanks

[protonLeah]

Why are you trying to get a total by adding values from a list box instead of the actual cells?

[tradinup2]

It seemed so simple to do it this way, the data in the list box is gathered from a dozen sheets.
The userform is where the info is consolidated and displayed to the user as a report with different options available to select.

[protonLeah]

You have:

Call YTDActualFill 'Fill the List Box

That indicates that you have a loop that's accessing only a single cell in several sheets. The code should total the variable as you progress through the loop rather than loading the values into a listbox.. You should show the code for YTDActualFill and post a sample workbook with several of the sheets being totaled.

[tradinup2]

The loop accesses 9 cells each on 12 sheets, I did however sum the total during the loop so I could get on with it. I still don't understand why the code I posted doesn't pick up the values of a bound column. Any ideas on that?

[mike7952]

Try

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

Note that the index of the first item in the list is ZERO, not 1. See Mike7942 above. As it is you will miss the first and crash at .ListCount since the last item is # ListCount-1. Still, it's a bad idea...

[tradinup2]

Please Login or Register  to view this content.

This info is as if the bound column = 1

[protonLeah]

You should post a sample workbook so we can stop guessing.
To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

[tradinup2]

No luck getting permission to upload.

[protonLeah]

What was the error message? Is the file larger than 1MB (must be les)?