[SOLVED] userform dynamic listbox to add & modify data

in the attached example i have a userform/listbox that will pull up data from a table. i'm having the following issues:


1. when you click on an item in the listbox. it populates the MONTH YEAR & AMOUNT text boxes for that specific line item. I'd like to then be able to change the amount and update that line item. right now the code is replacing the first instance of the specific job number. so in the attached example job 08-1000 has 2 billing entries Dec. & Jan.....when you try to modify the January line item it doesn't work.

2. the combo box MONTH has a row source of MonthList. It seems like the listbox on the sample is getting the month DECEMBER from column B (based on the date entry?)...instead of pulling up the month from column I....Also the month comes in in all CAPS (UCase) not like column I is (should be December not DECEMBER). If possible i'd need to have it pull the month from Column I because potentially the "date" could be different than the month the bill was entered.

let me know if this makes sense. or if I need to clarify this more. Thanks for the help!

Hi adamheon

This is rather a simple Fix to what you requested in your Original Thread...I'll look at it tomorrow. Bye the bye...the Toggle Buttons are FUBAR...in my opinion, the Toggle Button Code(s) need to be rewritten.

On your Main Userform

Rename

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

The code will then run when you change the combobox, your command button is then redundant.

Hi adamheon

Try the Code in the attached. I've also modified the Toggle Button Code.

Hi adamheon

If the example works perfect then there's something different about your sheet...can't trouble shoot without seeing the Offending File.

the example works perfect. When i put this into my sheet i'm getting a compile error for .myRow here

I don't know what you're looking for here...please explain...or show an example...

Also what would be the code to refresh the list box within the userform (lbbilledtodate) when you click update? So that you see the change that was made.

You're welcome...glad I could help. Thanks for the Rep.