Message box bleeds when moved on a userform

  • Thread starter ViViC via OfficeKB.com
  • Start date
V

ViViC via OfficeKB.com

Does anybody have idea as to stopping the bleeding when moving the message
box. I have used Screenupdating set to false but still does it. I am write
userform entries to excel database and must set the worksheet to a hidden
sheet. The user must not be allowed to change the worksheet or be able to see
it. This is driving mad, when fixed the project is finished. Please
 
H

Hennie Neuhoff

I'm also a novice and ecperienced the same problem - what I did was to set
the screenupdating to true - it solved my problem.
 
V

ViViC via OfficeKB.com

Thanks Hennie, I tried that but due to setup this didn't fix the problem. The
worksheet is hidden to the user and when data is added I need to change sheet
to activite and then deactivite at end. The screen updating causes the
bleeding. I was trying not to use on Exit event for all fields but it looks
that is the only way to go. Thanks anyway for your suggestion.
 
Top