Message box bleeds when moved on a userform
 

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

--
Message posted via http://www.officekb.com

Message box bleeds when moved on a userform
 

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


"ViViC via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

Message box bleeds when moved on a userform
 

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.

Hennie Neuhoff wrote:
I'm also a novice and ecperienced the same problem - what I did was to set
the screenupdating to true - it solved my problem.
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200809/1