My Excel VBA form "Whites" out
 

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

My Excel VBA form "Whites" out
 

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?

--
Regards,

OssieMac


" wrote:

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

My Excel VBA form "Whites" out
 

OssieMac,

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

Thanks
Dave

My Excel VBA form "Whites" out
 

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.

--
Regards,

OssieMac


" wrote:

OssieMac,

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

Thanks
Dave

My Excel VBA form "Whites" out
 

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)




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

My Excel VBA form "Whites" out
 

Thanks OssieMac

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


Dave

My Excel VBA form "Whites" out
 

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

My Excel VBA form "Whites" out
 

On Nov 27, 9:41 am, wrote:
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,
This solved the problem on all the computers ! Thanks !

Dave

My Excel VBA form "Whites" out
 

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)



On Nov 27, 9:41 am,
wrote:
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,
This solved the problem on all the computers ! Thanks !
Dave