View Single Post
 
Old 05-22-2014, 06:05 AM
jpb103's Avatar
jpb103 jpb103 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: May 2014
Location: Thunder Bay, Ontario
Posts: 58
jpb103 is on a distinguished road
Default Command button to show userform suddenly stopped working

I have a command button on a document that is supposed to show a userform I've been making. It worked seamlessly all day yesterday and today I come in to work and for the life of me I can't get it to work. Nothing has changed, and it suddenly does nothing. I've tried renaming it, i've tried deleting it and starting over with a new command button...nothing. When I try and run if from VB I get a "Run-time error '430': Class does not support Automation or does not support the expected interface".

*EDIT* I scrapped the document and started over from the original template after exporting the form and then importing it into the new document and creating a command button to show the form and now it works. I've changed nothing so I'm not confident that this problem won't pop up again.

Last edited by jpb103; 05-22-2014 at 06:41 AM. Reason: The plot thickens
Reply With Quote