1 of 2 userforms not working due to change event

[bitly]

I have an incomplete project I have been working on and do not want to move on until I get this problem resolved (little things like this bug me). Perhaps I just need a second pair of eyes. However, the problem that I am having is that I am using a userform to update cells in a sheet. I have 2 userforms that are very similar and one works and the other does not. The suppliers editing part of the program is working just fine. It updates as expected. The customers userform will only update the first name in the sheet; the other fields remain unchanged and refresh as the same while no changes are made in the sheet. I pretty much copied and pasted the code from the suppliers over to the customers and made all of the appropriate changes that I found. I have looked over it for hours on end and just cannot figure out why all of the information in the customers cannot be updated.

On a side note, while I was cleaning out most of the records from the sheet I got errors when I cleaned all of the records out, I have no clue how to handle these errors when there is no information in the sheets for the userforms to pull up. This error is not as pressing to me since the sheet will never be empty when in use, but it still bothers me knowing its there and not handled.

Thank you ahead of time for any help and sorry for the long first post, its 4 am. so it is possible I have rambled

Bitly

[davesexcel]

Step through your code. You will see what is going on.

[bitly]

To be completely honest I am not sure how to step through it in excel. But if you could give me a clue as to how to do so I would greatly appreciate it. However, if it is too involved to explain, I understand.

[davesexcel]

This is how I stepped through your code,it's on my You Tube channel.
Step through userform code

Possible issues could be, you are using rowsource for the combobox list or you are using rowindex. If you are not having that same issue in the other userform, find out the difference.

[bitly]

Yeah I looked at both and I cannot find the difference. It updates the the first name cell but no others even though the code is written the same for both click commands. I am still stumped on this one.

[bitly]

I have watched the video a few times in case I missed something. But I cant seem to find the difference between the one in customers that you posted and the one in suppliers in that same workbook. I know it has to be something simple, but Im still at a loss. Either way I have learned something new about stepping through code in a userform.

[bitly]

Ok, so at least I can see now what seems to be the problem, I just cant fix it for some reason. The 2 userforms are using pretty identical code with no real differences. The Suppliers userform does not have the same problem even with the code being nearly identical. However, the customer userform is resorting to the change event before the sub finishes executing, therefore, only the first cell gets changed before triggering this change event. After a bit of googleing I found the EnableEvents property which had absolutely no effect on the outcome no matter where I placed it. So I am still stuck with no differences between the 2 userforms to compare for issues, but I do know that for some reason after the first line in the click sub executes it goes to the change sub which causes all other cells to not update. Any suggestions?

[davesexcel]

That's what I found as well.

I still think it could be because using rowsource . When you changed the first cell(column A)
you have changed the rowsource value and the combobox_change event kicks in.

I populate my comboboxes & listboxes with either the range.value or with .additem.
I would also find the selection from the combobox and then populate the textboxes.

Rowsource maybe volatile and activates the combobox_change right away.

[bitly]

I just dont get how it works flawlessly for the other userform in the same workbook. It just does not make sense. At this point I want to make it work this way just out of principal instead of letting it defeat me lol. Anyhow I do appreciate your time and input in this matter.

[bitly]

I am going to mark this solved since I FINALLY figured it out. For anyone searching about a similar problem, the answer lay in the order in which you update the form and what you are using in your dropdown list. In my situation I was using the first name to populate the dropdown list box. The first item to be updated after hitting the edit button was the first name. As soon as you hit edit thinking it is going to go through and make all appropriate changes, it hits first name first and then that triggers the change event so none of the fields afterwards would be updated. All I did was simply move first name to be the last updated, and then the change event wouldnt take place until everything was updated. I cannot believe it took me this long to realize this and figure it out, but it was a very easy fix. Thanks for the help and input on this issue, hopefully this will help someone else in a similar situation.