VBA Design Mode Problem

Hi everyone.

I think a windows update has effected my VBA userforms both during design mode and at runtime.

I have a userform with a few Frames (used as a sort of drop down menu) and it few labels on it. Now this form worked perfectly the other day on tuesday 18th. since then there was a few updates, one being silverlight update. i know silverlight has nothing to do with VBA but... you never know. Im running windows 10 pro - and office 365.

So here is a list of the issues i'm now having with my user form.

- Labels will no longer appear transparent (both in Design and Runtime)

- Labels will no longer move to the Front or Back in their order on the form when layered. (appears in wrong order in both design and runtime) - labels strobe at runtime when moving the form.
- Frames have that little text caption you add to them - one is always blank, the others go blank as you click on them. (NOTE- appears to be because there is Label behind them which its "Z Order" gets messed up and appear on top of the frames)

I have opened old version of this workbook, same result.
I have removed the userform. and then reimported the userform. same result

i have included an image, as when i click on the attach button nothing happens.

also when i highlight this userform, the properties window is blank, yet other user forms when highlighted / selected will show their properties before a double click that then shows you the actual userform.

the other userforms appear correct, but if i add a transparent label to them they will remain opaque even at runtime.

any one have any ideas or solutions?

VBA problem.jpg

i dont think i can, its over 17mb in file size, and it wont let me upload the userform its self :/ maybe i will upload the userform to a google drive at this location

https://drive.google.com/file/d/0B_O...ew?usp=sharing

https://drive.google.com/file/d/0B_O...ew?usp=sharing

its just the user form.

regards

Just to add, when i open this workbook at work, in office 2007 it works fine, everything appears correct and the userform displays correctly at Runtime. im in the in process of doing a "Repair" of my office 365 to see if that has any effect on the workbook.

Ah ok, iv been searching the net high and low about this and couldnt find anything. Mind you i was searching for terms like: VBA Design Mode Problem, and things including Z-Order Design Mode, but that just always brought up how to set the Z-ORder of items.

thank you xlnitwit for looking into this with detail. any idea on how i can revert back to an older version of office 356?

i can confirm i have a fix for this, which is to revert back to an old version.

instructions here: https://www.msoutlook.info/question/784

takes some time, like it seems like office is not doing anything but sure enough it will revert back to an old version and your office VBA userforms are good to go

i cant belive office at the very least hasn't released an update that at the least reverts back to before the issue, while they fix the issue.

Exercpt from M'soft site:

"I can assure you that the Office team is aware of the pain here and is treating the fix accordingly. I don't have exact dates, but I am hoping you see it within a couple of weeks. Insider Fast users will see the fix first in their next build, tentatively scheduled for later this week."

Would like to really let them feel some PAIN also for not debugging their updates...transparency and Z-order are pretty basic things that are easy to spot during a proper debugging process. Makes one wonder about updates to the overall operating system of Windows 10 which will be forthcoming (last update lost all of my internet connections and turning on/off the computer didn't help). Finally tried just a refresh and got the internet connection back on the network.