Hi there
I have coded a financial calculator and it works perfectly fine, well on most computers.
This financial calculator works as follows:
1. The user enters in all the input on a user form
2. Click on the calculate button and all the calculations are displayed on the user form
3. Click on the report button (This is where the problem comes in)
The report button should display another form with all the figures. It use to display everything correctly in Excel 2003 that runs on Windows XP but I was having a problem with Excel 2007 where it displays a black background on the user form and you can't see anything. I thought the problem would be with Excel 2007 since it was working fine on Excel 2003 but now I have tested it on another computer with Excel 2003 that also runs on Windows XP and it is doing the exact same thing. I tried changing the background color via the VBA code but that doesn't help too.
Could you please help with any suggestions?
Thanx in advance
Qudsi
I have coded a financial calculator and it works perfectly fine, well on most computers.
This financial calculator works as follows:
1. The user enters in all the input on a user form
2. Click on the calculate button and all the calculations are displayed on the user form
3. Click on the report button (This is where the problem comes in)
The report button should display another form with all the figures. It use to display everything correctly in Excel 2003 that runs on Windows XP but I was having a problem with Excel 2007 where it displays a black background on the user form and you can't see anything. I thought the problem would be with Excel 2007 since it was working fine on Excel 2003 but now I have tested it on another computer with Excel 2003 that also runs on Windows XP and it is doing the exact same thing. I tried changing the background color via the VBA code but that doesn't help too.
Could you please help with any suggestions?
Thanx in advance
Qudsi