Followup question regarding this ListBox and passing Values to Labels

[JJFletcher]

Hello All,

I keep getting the following error and I have checked everything and cannot find where the error is at!

error1.jpg


Any Thoughts I would appreciate!!

Rgards,

John

[Corbett]

You have password protected the project which makes it tricky to help.....

[JJFletcher]

Hi Corbett,

Sorry about that - I have corrected that!

John

[romperstomper]

You populated the control using AddItem so you can only have 10 columns. You need to use an array or a range on a sheet to have more than 10.

[romperstomper]

For example:

Please Login or Register  to view this content.

[torachan]

you have hit the limitation of the .Additem method of populating combobox/listboxes (only allows 10 columns max.).
you need to use an array and use the .List property of the listbox.

[JJFletcher]

Hi Rorya,

TY So much - That fixed it!!!

Regards,

John

[JJFletcher]

Hello All,

After the change to the code the Search no longer allows the User to enter partial data and then perform the search - Can that be added back?

Regards,

John

[romperstomper]

What do you mean? I didn’t change the search method.

[JJFletcher]

Hi Rorya,

Thanks for the feedback... It should be able to search by any column by entering partial data into the TextBoxes, Name, Sup etc... the code now seems to be directed primarily to

Please Login or Register  to view this content.

And I apologize in advance - it did seem as though when first seeking a solution here in the Forum that the search method may have appeared as numeric only....

Regards,

John

[romperstomper]

OK, you'll need a slightly different approach for partial matches as some of your columns are numeric. Try this:

Please Login or Register  to view this content.

[JJFletcher]

Hi Rorya,

Works like a charm.... OUTSTANDING!!!!!!

Thanks much... I would give you another Rep but the system won't let me!

Regards,

John

[romperstomper]

No worries - just happy to help.

[JJFletcher]

Hello All,

Followup question for this ListBox...

My Listbox is call Results and I have read somewhere that the columns can pass the value (Total) to a Label...

Please Login or Register  to view this content.

Would this be accurate???

Regards,

John

[romperstomper]

No. Which value from the listbox are you trying to pass? A specific row and column, or the total of a particular column?

[JJFletcher]

Hi Rorya,

yes - I would like to pass the value Total of all columns to labels below the Listbox Columns 7 to 15

I would assume that it could be a single column (7) and then it can be replicated as needed for each column in the ListBox.

[romperstomper]

You'd need something like Application.Sum(Application.Index(Me.Results.List, 0, 7)) and so on.

[JJFletcher]

Sorry - please disregard - I got it
UGH!!!

[romperstomper]

What do you mean? You just use what I showed.

[JJFletcher]

Thanks for the feedback - I got it!!

I appreciate you