Activex Component Not Correctly Registered Error 336 Excel
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Error 336 To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 7 of 7 Error 336 Thread Tools Show Printable Version Subscribe to this Thread… Mark this thread as solved… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-17-2005,12:05 PM #1 SSaxman Guest Error 336 I have a spreadsheet that I created in Excel 2003 on my work laptop. Within that spreadsheet I have a button that actiavtes a user form that I created in VBA (UserForm2). I had to switch computers yesterday because my other one crapped out on me. On the new computer (same OS and Office Version), when I open the spreadsheet and click the button to access the user form or if I try to edit the user form in VBA, I get an error message stating "Component not correctly registered." When I click 'Help,' it expands the error: "ActiveX Component not correctly registered (Error 336): The ActiveX component has not been properly registered in the system registry." I am pretty much a novice when it comes to VBA, having just recently gotten my feet wet. Can anyone please tell me how I can fix this problem? Thanks! Register To Reply 09-17-2005,02:05 PM #2 Tom Ogilvy Guest Re: Error 336 Let's try the simplest first close excel. go to the windows temp directory and delete any files there and any subdirectories to the temp directory which relate to Excel or Office or VBA. Now Go to the Windows=>Run menu enter Excel.Exe /UnRegServer and click OK. then repeat with Excel.Exe /RegServer This should restore the Excel registry entries. Then start Excel in an in a new workbook, go to the VBE and do Insert Userform now in the VBE go to tools => References, you should have a reference to Microsoft Forms 2.0 Object Library If you do, then you should try opening your problematic workbook and see if it will work. -- Regards, Tom Ogilvy "SSaxman"
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Office VBA language reference Visual Basic language reference Error Messages Error Messages ActiveX component not correctly registered (Error 336) ActiveX component not correctly registered (Error 336) ActiveX component not correctly registered (Error 336) #Else clause must http://www.excelforum.com/showthread.php?t=468501 be preceded by a matching #If #Else If, #Else, or #End If must be preceded by a matching #If #ElseIf must be preceded by a matching #If or #ElseIf and followed by an #ElseIf, #Else, or #End If
Forums Excel Questions ActiveX component not correctly registered Results 1 to 7 of 7 ActiveX component not correctly registeredThis is a discussion http://www.mrexcel.com/forum/excel-questions/166183-activex-component-not-correctly-registered.html on ActiveX component not correctly registered within the Excel Questions forums, part of the Question Forums category; I received Error 336. I looked it up and it says: ActiveX component not correctly registered Does anybody know what ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread activex component Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Oct 5th, 2005,05:20 PM #1 Todd Bardoni Board Regular Join Date Aug 2002 Location Rochester, MI USA Posts 3,044 ActiveX component not correctly registered I received Error 336. I looked it up and it says: ActiveX component not correctly registered Does anybody know what activex component not causes this and how to fix it??? Share Share this post on Digg Del.icio.us Technorati Twitter Todd "I'm a Data Anlyst(intermediate) and have no idea what it's all about." Reply With Quote Oct 5th, 2005,06:32 PM #2 Todd Bardoni Board Regular Join Date Aug 2002 Location Rochester, MI USA Posts 3,044 bump Share Share this post on Digg Del.icio.us Technorati Twitter Todd "I'm a Data Anlyst(intermediate) and have no idea what it's all about." Reply With Quote Oct 6th, 2005,10:13 AM #3 Todd Bardoni Board Regular Join Date Aug 2002 Location Rochester, MI USA Posts 3,044 bump bump Share Share this post on Digg Del.icio.us Technorati Twitter Todd "I'm a Data Anlyst(intermediate) and have no idea what it's all about." Reply With Quote Oct 6th, 2005,10:54 AM #4 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California USA Posts 11,068 My first troubleshoot idea would be to see if there is a userform in the workbook, or OLE's on a sheet, and are there any controls you imported or