Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA - my toolbox controls have dissappeared
I've been developing an Excel App with about 4 User Forms. Recently, all the
controls in my Toolbox, except for "Select Objects", have dissappeared. When I right-click and select "Additional Controls...", sure enough everything is unchecked. So, I go ahead and re-add the "Microsoft Forms 2.0..." controls and they show up again in my toolbox. However, if I exit the VBE and Excel and go back in, once again my Toolbox is empty. What's going on?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA - my toolbox controls have dissappeared
I had the same problem a little while ago and 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!) Nazerv70 wrote: I've been developing an Excel App with about 4 User Forms. Recently, all the controls in my Toolbox, except for "Select Objects", have dissappeared. When I right-click and select "Additional Controls...", sure enough everything is unchecked. So, I go ahead and re-add the "Microsoft Forms 2.0..." controls and they show up again in my toolbox. However, if I exit the VBE and Excel and go back in, once again my Toolbox is empty. What's going on?? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA - my toolbox controls have dissappeared
The bad news - I don't think Tom Ogilvy's comments apply here because even
after selecting "Additional Controls..." and re-adding the controls I needed, they would still disappear again the next time I opened the VBE. The good news - Rob Bovey's suggestion did the trick!! So thanks Dave for passing that information on. Can anybody explain what could have caused that to happen, what could have caused my Excel.box file to get corrupted? Thanks. "Dave Peterson" wrote: I had the same problem a little while ago and 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!) Nazerv70 wrote: I've been developing an Excel App with about 4 User Forms. Recently, all the controls in my Toolbox, except for "Select Objects", have dissappeared. When I right-click and select "Additional Controls...", sure enough everything is unchecked. So, I go ahead and re-add the "Microsoft Forms 2.0..." controls and they show up again in my toolbox. However, if I exit the VBE and Excel and go back in, once again my Toolbox is empty. What's going on?? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA - my toolbox controls have dissappeared
I have no idea what causes the excel.box file to get corrupted.
The good thing is that it's only happened once (to me). Nazerv wrote: The bad news - I don't think Tom Ogilvy's comments apply here because even after selecting "Additional Controls..." and re-adding the controls I needed, they would still disappear again the next time I opened the VBE. The good news - Rob Bovey's suggestion did the trick!! So thanks Dave for passing that information on. Can anybody explain what could have caused that to happen, what could have caused my Excel.box file to get corrupted? Thanks. "Dave Peterson" wrote: I had the same problem a little while ago and 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!) Nazerv70 wrote: I've been developing an Excel App with about 4 User Forms. Recently, all the controls in my Toolbox, except for "Select Objects", have dissappeared. When I right-click and select "Additional Controls...", sure enough everything is unchecked. So, I go ahead and re-add the "Microsoft Forms 2.0..." controls and they show up again in my toolbox. However, if I exit the VBE and Excel and go back in, once again my Toolbox is empty. What's going on?? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls Toolbox | Excel Discussion (Misc queries) | |||
toolbox controls in excel are invisble ? | Excel Worksheet Functions | |||
Additional toolBox controls | Excel Programming | |||
Excel Controls Toolbox - Checkboxes, etc | Excel Programming | |||
Additional ToolBox Controls | Excel Programming |