ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Runtime error 91? (https://www.excelbanter.com/excel-programming/366173-runtime-error-91-a.html)

leonidas[_34_]

Runtime error 91?
 

Hi,

I am creating a program (I can't attach it because it exceeds the 100kb
limit, but I can mail it to you!!!), but I get an error and I can't seem
to find the problem.
When I start up the excel-file and try to run the macro
"GegevensAanpassen" on any row where it is possible (I enter data in
the 2 textboxes on the pop-up screen and check the checkbox "ja" (=yes)
and press the "OK" button), I get an runtime error 91. The excel-file
CANNOT load the userform "FormUitgangspunten".
But when I start up the excel-file and first run the macro
"RijInvoegen" (=insert row) and enter the data in the pop-up screen or
even when I directly push the "Cancel" button and then again try to run
the macro "GegevensAanpassen" ( and enter data in the 2 textboxes on the
pop-up screen and check the checkbox "ja" (=yes) and press the "OK"
button) it DOES work.
Can someone help me find out what the problem is? Thanks in advance!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=558107



All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com