VB6 - runtime error when displaying form

[grip88]

I have a worksheet with a button that links to a form. When i click this i get the 'runtime error 9 - subscript out of range'

When i debug it highlights: frmdaily.show in the connected module.

This has all worked fine for a number of weeks so I am stumped as to why it would stop now. Even when i load the form in vb i get the same error.

Thanks in advance.

 

[grip88]

I now have a run-time error 7: could not find specified object when clicking the button on the worksheet.

Thanks