View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Control Toolbox does not appear when trying to design a Userform!

I had a similar problem a little while ago. The toolbox would appear, but all
the icons were missing.


I got this message from Rob Bovey:

With Excel shut down, search your hard disk(s) for a file called
Excel.box (it's the VBE toolbox equivalent of an Excel .xlb file). Delete it
and then restart Excel. That may do the trick.


And this message from Tom Ogilvy:

It appears to be just a special multipage control.

If you right click above the tabs, you get a shortcut menu that allows you
to add and delete pages.

If you right click on one of the tabs, you get the additional controls popup
menu. Select that and just click the controls you want on the tab/page.


I believe I did a little of Tom's suggestion, until I broke down and just did
them all at once with Rob's suggestion.

(It scared the heck out of me!)

=======
You may want to rename excel.box to excel.boxOLD--just in case this doesn't help
and you want to get it back.



wrote:

Hi people -

I am trying to design a Userform in Visual Basic Editor in Excel 2002,
and I can't get the control toolbox to show up (making my userform
rather useless).

Anyone have any tips? I read something on MSDN about an MS Access bug
where the Toolbox is off the viewable area and you can use VBA to
re-center it... but I can't seem to get this to work in Excel.

Help!


--

Dave Peterson