Re: Error 336

Error 336 means:

The ActiveX component has not been properly registered in the system
registry.

but you said it is properly registered.
And if you successfully followed my instructions, then you were able to
create a userform in a new workbook.

Perhaps you have a non-msforms 2.0 control on your userform and that is what
is not registered.
--
Regards,
Tom Ogilvy

"SSaxman" <SSaxman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65DB10FF-DB90-4CD6-9937-E789AA6DD1D5@xxxxxxxxxxxxxxxx
> Anyone have any ideas?
>
> "SSaxman" wrote:
>
> > Tom,
> >
> > I read your directions completely before following them. I did
everything
> > you listed, and I did have a reference to the Microsoft Forms 2.0 Object
> > Library, however, when I attempt to edit the user form or activate it
from
> > the spread***, I continue to receive the same error message. Any
other
> > ideas?
> >
> > Thank you!
> >
> > Ty
> >
> > "Tom Ogilvy" wrote:
> >
> > > 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" <SSaxman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:A1DFE17E-6762-4C90-B99D-3363D2086A32@xxxxxxxxxxxxxxxx
> > > > I have a spread*** that I created in Excel 2003 on my work laptop.
> > > Within
> > > > that spread*** 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 spread*** 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!
> > > >
> > >
> > >
> > >


.

Loading