VBA code not executing fully in save on-exit scenario

[aguilarpro]

Hello all,

Just a quick question to what is wrong with this code. I was able to capture the events of when the code will fully execute and when it won't. Initially I had issues with message boxes displaying values for testing purposes and I realized that when a box is popped up it destroys variable data (need to confirm that this is the case).

My issue currently is that I have a form that I open it works as long as I don't save it "while closing the file" (confirmation window to save). However if I open the file and then use the save button it will save and work ok sometimes but if I move the selection cell and then close the file and it asks me to save, I hit save and when I open it back it won't work fully and I don't know why, I basically have to click on a different random cell and save the file and my form will execute as intended again.

Here is my code and the files are also attached for working and non working version.

The parts where it does not grab the data is on the first Code variable, on the working version I do get values but on the non-working I get an empty result.

Dock-LogWorking.xlsmDock-LogNotWorking.xlsm

[skywriter]

It would be helpful if you would be specific instead of generic. Tell use exactly what you are doing when you have a problem. What did you open what did you click on what did you enter in a cell etc. etc. etc.

[aguilarpro]

So, the following code has a form that has a display feature on both listboxes if certain criteria is met based on user input, then it selects the last entry to get the value of "Code" number, with case statement I called the next letter based on the value of lbCode listbox. The issue I have here is that I sometimes get the Code value from the listbox but sometimes I don't, even if I run the same search criteria without adding anything to the list. This happens when I close the file and open it again and save it on exit dialog, or just sometimes at random. I can't find the root cause, like I said, it works and doesn't sometimes. I sometimes thought that if I ran it from the vba menu it would work but it would also work from the button on the excel file itself.

Please Login or Register  to view this content.