forms - Runtime Error 2147024809 (80070057): Could not find the specified object -


i ran issue project throwing me loop. project no longer recognizing 2 of 11 forms have been in existence virtually since program's inception. names of forms have not changed, nor has code calling forms changed. these 2 forms being called without issue , runtime error exists. 2 forms not coming anymore "vacation_days_form" , "vacation_holidays_form", code below explains. issue "holidays_form" userform, being called no data being outputted program. again, form working fine , not after no code pertaining form changed. 1 of main forms works code below "normal_iteration", embedded in module1 (not userform). below code:

private sub userform_initialize()     options         .additem "no vacation or holidays"         .additem "vacation"         .additem "holiday"         .additem "vacation & holidays"     end end sub  private sub vacation_options_select_click()     vacation_options_form.hide     dim list_options integer     list_options = 0 options.listcount - 1         if options.selected(list_options) = true             if options.list(list_options) = "no vacation or holidays"                 call normal_iteration             elseif options.list(list_options) = "vacation"                 vacation_days_form.show             elseif options.list(list_options) = "holiday"                 holidays_form.show             elseif options.list(list_options) = "vacation & holidays"                 vacation_holidays_form.show             end if         end if     next end sub 

to answer these questions ahead of time: 1) yes, have checked see these userforms still exist in program; , 2) yes, userforms named called out in code above.

thanks in detecting issue. please let me know if there additional code necessary me post.

regards,

jordan

i ended redoing project, copying code, forms, formatting, etc. workbook, starting scratch. still have no idea happened. ms office 2007 appears have significant reliability issues. help.


Comments

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

php - render data via PDO::FETCH_FUNC vs loop -

The canvas has been tainted by cross-origin data in chrome only -