I have a similar problem with Excel 2003, although it is not related to a
form and I currently do not have any Add-Ins selected. I believe it's
related to my system's Visual Basic component registration, because
"Microsoft Visual Basic" is displayed in the title bar of both the error:
"336" and the error: "component not registered correctly." dialogues I
experience on startup, shutdown, and when using keyboard
shortcuts. If I use menu commands instead of the shortcuts, I do not
experience the problem.

I've installed the latest Office updates, but this doesn't appear to update
or repair any VB files, and I think that's what is necessary. Any
suggestions for repairing my system's Visual Basic files or component
registration?

Thank you, JT


"Tom Ogilvy" wrote:

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" wrote in message
...
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 spreadsheet, 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" wrote in message
...
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!