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
Post a Comment