My Excel VBA form "Whites" out

  • Thread starter Thread starter david.r.bratkowski
  • Start date Start date
D

david.r.bratkowski

Hi
Hope someone can help. I have a Excel VBA form that "Whites" out
unless I have the VB editior open. I've looked at things like changing
the DrawBuffer space and even putting a pause in the code. Is this a
problem with Excel VBA ?

Thanks
Dave
 
Hi Dave,

What do you mean by "Whites out"?
How much can you see?
Do you loose the background color or can't you see anything?
Have you set the background color in properties?
 
OssieMac,

The form just turns white like it's loading. I
can't view any of my controls.

Thanks
Dave
 
Hi Dave,

I am sure that I have seen something about a bug in Userforms that raises
its ugly head after multiple changes to the form but I can't find where I saw
it. However, if I remember correctly, the fix was:-

Backup the workbook first in case of problem.

Right click on the userform name in the VBA project explorer and export it
to a file. (Filename will default to userform name with .frm extn. (Ensure
that you note where you save it and the file name).

Right click on the userform in the project explorer again and remove it.

Select File then Import file and locate and open the saved file.

If that does not work then I am fresh out of ideas.
 
Dave,
Something else you can try is use "Repaint" in your form code.
The single word will work or you can use Me.Repaint.
You can use it in several places if necessary.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



<[email protected]>
wrote in message
Hi
Hope someone can help. I have a Excel VBA form that "Whites" out
unless I have the VB editior open. I've looked at things like changing
the DrawBuffer space and even putting a pause in the code. Is this a
problem with Excel VBA ?
Thanks
Dave
 
Thanks OssieMac

Before I posted this message I tried your suggestion. I
still seem to have the problem :(


Dave
 
Jim,
Thanks ! Your suggestion works on my computer. I'll need to
check it on some others as the number of times the screen whited out
seems to vary depending on which computer was running the code.

Dave
 
Jim,
Thanks ! Your suggestion works on my computer. I'll need to
check it on some others as the number of times the screen whited out
seems to vary depending on which computer was running the code.

Dave
Click to expand...

Jim,
This solved the problem on all the computers ! Thanks !

Dave
 
Dave,
You are welcome, and thanks for the feedback.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



Jim,
Thanks ! Your suggestion works on my computer. I'll need to
check it on some others as the number of times the screen whited out
seems to vary depending on which computer was running the code.
Dave
Click to expand...


Jim,
This solved the problem on all the computers ! Thanks !
Dave
 
Back
Top