Thread: Error 336
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SSaxman SSaxman is offline
external usenet poster
 
Posts: 3
Default 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!