View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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