Hello everyone.
I have searched for this problem and solution across the web. I have tried the few solutions I found and nothing works. The occurrence also appears to be random...so here we go.
I have some User Form with MultiSelect listboxes. When the user double clicks in a range specific to these forms, if the cell was blank, the form should populate with no values = true. Yet, I often get the forms opening with boxes checked, no discernable pattern to which are checked. I clear the selections, save, reopen...flip a coin, could be all blank (good), could be random checked boxes (bad). Same goes for a cell with the concatenated data to be read back in for editing.
If I run in debug mode, OR set a stop in the code, and press F5 to run, the bug never happens. I tried adding time delays, no change. I tried to write to a not visible list then copy to the visible list, no change. I tried to open a msg box saying something like "Did you really want to edit this cell - but really I am just building in a stop to fix a bug I created and am not smart enough to fix", no change although (and not the real message), users DID NOT WANT TO have to click OK to close a message...they said with 1000's of lines to work through, it had to go anyway.
The column PROGRAMS is the one I see it most in....MITIGATION STRATEGY sometimes...Planned Activities not yet, and there are Check boxes in the TrigE form, I don't see it there (I think).
Like I said, it often takes multiple attempts to make it happen. Sometimes it only happens when I use another form then one of these listboxes. My boss is beginning to think all those years I spent studying engineering has been for naught if I can't solve problems like this - I fear I am beginning to agree with him. (:
Any thoughts? I've attached everything, and removed the proprietary data but what you have is valid. If there is something there, not a worry. My work is in risk and it is always supposed to be transparent so nothing is in the files not already available to the public.
As with my first and only other post, it I broke a rule, I will fix immediately.
Thanks to everyone, your help when I searched for other problems I had has been perfect.
Brian
Bookmarks