An amateur mistake

A

Andrew_Rossington

Board Regular
Joined
Feb 12, 2007
Messages
121
From: http://www.mrexcel.com/board2/viewtopic.php?t=295960


godevs,

Welcome to MrExcel.com!

If you right-click on your controls toolbox toolbar you'll see an option for additional controls. Try adding the Calendar Control xx.0 (good) or scroll down to Microsoft Date and Time Picker Control x.0 (better) and see if those don't work better for you.
Click to expand...


I feel kind of dumb here... I was trying this solution for myself, and I accidentally clicked on "Delete Page" after right-clicking the toolbox. Now all of my Tools are gone.

Could someone please point me in the right direction for getting them back?

Thanks very much.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Hmmm, where did you find the "delete page" option??

Did you just hide the toolbar? Try View>Toolbars>ControlToolbox
 
Upvote 0
Hmmm, where did you find the "delete page" option??

Did you just hide the toolbar? Try View>Toolbars>ControlToolbox
Click to expand...

I'm referring to the toolbox in the Visual Basic editor.

On the toolbox, the list of available tools are displayed under what could be called a tab (or a page in this case). I assume this is because you can add more controls (as per the post linked previously) which could then be sorted onto separate pages.

I think what I did was delete the page with the list of default controls on it. If you right-click next to the tab, you'll get a list of options:

New Page
Delete Page
Rename
and so on.

I clicked Delete Page.
 
Upvote 0
Which version of Excel are you using? This tab/page stuff is not sounding very familiar. I have my toolbox which I right click to bring up the list of additional controls. There does not appear to be a delete page option :unsure:
 
Upvote 0
I see it (don't know how to fix it, though). On the Controls Toolbox, right-click the TAB and that shows the menu that Andrew is talking about...
 
Upvote 0
Ah, ok, got it!!

You’ll have to forgive me for not trying to re-create your problem as I haven’t been able to locate a “restore default toolbox” kind of option. According to Help, deleting the page also deletes all the tools on that page. So, I believe that the only solution will be to add a new page and then re-add each of the controls. If it helps, the default controls in my toolbox are as follows:

Microsoft Forms 2.0 CheckBox
Microsoft Forms 2.0 ComboBox
Microsoft Forms 2.0 CommandButton
Microsoft Forms 2.0 Frame
Microsoft Forms 2.0 Image
Microsoft Forms 2.0 Label
Microsoft Forms 2.0 ListBox
Microsoft Forms 2.0 MultiPage
Microsoft Forms 2.0 OptionButton
Microsoft Forms 2.0 ScrollBar
Microsoft Forms 2.0 SpinButton
Microsoft Forms 2.0 TabStrip
Microsoft Forms 2.0 TextBox
Microsoft Forms 2.0 ToggleButton
 
Upvote 0
Ah, ok, got it!!

You’ll have to forgive me for not trying to re-create your problem as I haven’t been able to locate a “restore default toolbox” kind of option. According to Help, deleting the page also deletes all the tools on that page. So, I believe that the only solution will be to add a new page and then re-add each of the controls. If it helps, the default controls in my toolbox are as follows:

Microsoft Forms 2.0 CheckBox
Microsoft Forms 2.0 ComboBox
Microsoft Forms 2.0 CommandButton
Microsoft Forms 2.0 Frame
Microsoft Forms 2.0 Image
Microsoft Forms 2.0 Label
Microsoft Forms 2.0 ListBox
Microsoft Forms 2.0 MultiPage
Microsoft Forms 2.0 OptionButton
Microsoft Forms 2.0 ScrollBar
Microsoft Forms 2.0 SpinButton
Microsoft Forms 2.0 TabStrip
Microsoft Forms 2.0 TextBox
Microsoft Forms 2.0 ToggleButton
Click to expand...


Problem solved!

Thank you to everyone who took the time to help out, it is greatly appreciated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
L
  • Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
H
  • Question
Calendar userform-text selection
Replies
1
Views
6K
hissonrr
H

Forum statistics

Threads
1,215,636
Messages
6,125,959
Members
449,276
Latest member
surendra75

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top