which of these toolbars provides the better 'controls' to paste onto worksheets (as opposed to UserForms)? For those wondering, both toolbars contain some apparently similar controls, e.g., combo box, radio button, spinner etc. but there are differences in their behaviour it would seem...
View 2 Replies
I'm using forms toolbox to add textboxes on an user input sheet for my workbook.
There would be 3 textboxes included in the group box added to the user input sheet.
I'm struggling with the code to accomplish the following:
Textbox1 - is a % input. I would like the input to be formatted to 2 percentage points. In other words, if someone enters 2, it will show as 2.00% and I want the 2.00% to be recognized as such in the spreadsheet calculations. In other words, the input is used in the calculations in another sheet.
Code thus far (and I may be offbase on this):
Private Sub TextBox1_Change()
Sheets("Sheet2").Range("rate").Value = TextBox1.Value
End Sub
Problem - the cursor is not moving and the result of the input is not showing. I would like the cursor to move from textbox1 to textbox2 to textbox3 by tab or enter button.
Textbox2 - is decimal input. I would like the input 5, it will formatted to show as 5.0. This input is used in the calculations in another sheet.
Private Sub TextBox2_Change()
Sheets("Sheet2").Range("multiple").Value = TextBox1.Value
End Sub
Textbox3 - is a result box based on the inputs from textbox1 and textbox2. I would like the result to be shown to the user in this textbox3 and for it to be greyed out and not to accept any inputs from the user.
That is, it is not an input box but rather a results box.
I’m trying to do a pull down with scrolling ability in a cell that references another worksheet. I want to look like the one that occurs when you use “Data Validation”. I’ve seen this in another workbook and it does not look like the used VBA.
View 4 Replies View RelatedMy boss has passed me his laptop that he had been designing a spreadsheet on (Excel 2000). The 'forms' toolbar has completely disappeared. When I right click the area where the toolbars are normally docked it lists every one except forms. clicking customise appears to list a few more menus - but no sign of FORMS. If I click 'new' in customise and type in Forms for the name it tells me 'a toolbar named 'forms' already exists' (so where is it!)
how I can get the toolbar back -
I've got the bare bones of a toolbox control on my userform but I can seem to find anyway to refer to the buttons and control them (I’ve tried using the properties page but it doesn't seem to give me the options I need). I want to be able to add a macro and a picture to the buttons, is this possible?
Eg.
With Userform1.Toolbar1.button("x")
.image/picture/faceid = “x”
.action = "macro1"
end with
I've looked for ages on the board but can only find threads on creating toolbars in the application, not on userforms.
I am an average user of excel and i am wanting some help with macros. I can record macros, that i do understand. Its the part where you can assign the macros to the Checkbox i have created.
The effect i am trying to create is that when the checkbox has a tick in it, certain properties happen to a cell. But when the checkbox has no tick in it something else happens to the cell. I have recorded 2 macros for what i want to happen its just getting it associated with the true/false of the checkbox.
I have no Visual Basic Experience and i have tried reading other posts, but the code just goes right over my head at the moment. Thanks in advance for anyhelp. I can attach the spreadsheet etc...
I want the contents of the text box (which will be input by the user) to update a cell in another worksheet. I have found numerous examples of how to display the contents of a cell in the text box but I want to know how to display the text box contents in a cell.
View 9 Replies View RelatedI am using the following code to create an Excel toolbar custom control Button. What would be the VBA code to change the color of the image I have chosen? ....
View 6 Replies View RelatedI've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.
I understand this may be changed in the 2007 version, but I’m using Excel 2000
There is something that is bothering me in excel. Every time I open a workbook, on my toolbar appears the "Reviewing" one. I tried to unchecked it from the customize toolbar option but still appears on opening a new workbook ((.
View 2 Replies View RelatedI downloaded the calculator toolbar, and for some reason it doesn't look right, it doesn't resemble a calculator layout at all.
The numbers are skewed, as though the layout is in landscape view instead of portrate. I've tried repeately to delete it from the toolbars menu option, with no success. It's become annoying.
I have a project management workbook I created that tracks the status of projects and their associated "grocery list" of items being pursued to complete each project. The user needs to indicate the status of each grocery item by setting the item red, yellow, green, or blue; each color has an associated number (1, 2, 3, 4) so the overall project status can be averaged. I am currently using a command button and Select Case statements to allow the user to toggle through the various status colors with a single button. The problem is, I still have to have a separate command button on each sheet which takes up a lot of space.
I would like to have a single toolbar that is available on all sheets, much like an Add In creating a menu, but it is impossible for me to personally install a custome toolbar or an Add In on each user's PC. I need something imbedded in the actual workbook that will propogate the toolbar on its own.
how i can create a replacement toolbar within excel, that will run once the file is opened. replacing the file, edit, etc.
View 3 Replies View Relatedi have been having this problem with my version of excel at work and it is driving me crazy. First of all this is excel 2000. For a while now I have been unable to use the control toolbox - when I click it - nothing happens. In the meantime I havent been doing anthing really serious so I used the forms toolbar. I have tried using the control toolbox in word - and it works - just in case someone had been messing around and uninstalling things. Is there anyway that I have hidden it somewhere?
View 6 Replies View RelatedI have added a button to asign a macro to but for the life of me cant see how to "activate" the button. I am trying to click the button to make the macro run but it keeps selecting the button like it wont come out of design view.
View 4 Replies View RelatedI've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below
pukks Auto Merged Post;Doh Doh and double doh!
Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.
i've gotta demo an Excel app in a few days and this never really bothered me, but someone recently pointed out that it can get distracting for the Control Toolbox to pop in and out randomly. the form is being built for use by other staff, and i suppose it would also be distracting for them if the toolbox arbitrarily appeared here and there. is there a way to turn it off?
View 2 Replies View RelatedVersion: excel 2003
OS: Win XP
Currently using VBA do develop a tool for Excel. I've downloaded a .ocx control and am wondering how one would go about adding it to the toolbox?
I have a macro and I want a button on the toolbar, once clicked on the button, I want the macro to run.
Is there any way to do this. If this can be done using add-ins, I doesn't know how to create a button for the same.
I use Excel 2000.
I want to hide all toolbars when I work.
I know how to hide them during a session, but when I exit and reboot Excel, the "standard" toolbar always returns.
Is there some way to hide the "standard" toolbar permanently?
I am running Excel 2003 and in my workbook I created a macro and assigned it to a toolbar comman button, "Copy Filtered Data". This macro copies the visible data into a new workbook.
This works well but others in my company will also be accessing this workbook from a sharepoint and I discovered that when they open it this command button is not on their toolbar.
Would anyone know what I need to do to have this button load on the toolbar when the workbook opens?
Also, I would like this button to either unload or greyout when the workbook that this button is intended for is closed.
I have created a toolbar button to save a file as a specific name based on a cell value. The macro runs fine, but the button changes priority when the new file is saved.
i.e. the original file is called "quoting_tool" and the newly created file is called "quoting_tool_'B3'". However, the next time I click this button in the original file, it requests the new file as the home of the toolbar button. I have tried saving the original file after adding the button, but that doesn't work.
Is there a way to name a combo box from the form's toolbar? I know you can give a name a combo box from the activex control toolbar but I am puzzled with the attached spreadsheet. The code is referencing a name "Combo Box 2" and I am wondering how they assigned a name to a combo box from the forms toolbar. See attached file for more detail.
View 3 Replies View RelatedI coppied this code from: http://www.contextures.com/xlToolbar02.html. Modified it to show menus but how to add sub menus? (This is the only code I found that works on Excel 2000, so far).
View 4 Replies View RelatedCross-Post
http://www.mrexcel.com/forum/showthr...=1#post1994747
I need a way in VBA to disable the Mini Toolbar from the right-click menu.
using excel 2003.
I have the following code to display a toolbar everytime my template is open
'Show Custom Toolbar "Trade Log" on Workbook Open
On Error Resume Next
With Application.CommandBars("Trade Log")
.Position = msoBarFloating
.Left = 5000
.Top = 600
.Visible = True
End With
End Sub
(hope i wrapped the code quotes correctly this time ))))
I noticed that when you drag a custom toolbar to the far right of your screen - it locks in to a vertical toolbar space.
How can i position my toolbar in this place automatically by modifying the above code.
I hate this toolbar.
I have no need for it but would like it to remain in the list of available toolbars (eg when i go View>Toolbars).
When i uncheck it from the list it disappears (hooray!) but the little b*stard is always back on my screen the next time I open Excel (this is in contrast to any other toolbars I hide/make visible which are always hidden/visible as expected - hence I don't think it's an .xlb problem).
has anyone got an explanation as to why and, better yet, a way to get the problem child off of my Excel (without removing it from the toolbar menu list)? Because I'm at work I can't modify Registry settings by the way.
Is there anyway to permanently removed the reviewing toolbar . Everytime i open a document, the reviewing toolbar will come out.. and i got to manually remove it again.
is there a way to remove it by default unltil i request it to be turn on.
I've created a custom toolbar via Excel's toolbar wizard, to which I have added several macro buttons. However, when clicked, instead of running the assigned macro, Excel instead attempts to open my already open file?? I think I read something about having to manually change the buttons to refer to a .xla ??? Not sure though.
View 3 Replies View RelatedI have created 2 toolbar buttons which were attached to a macro that ran the original 'EditTenancy'. I now want to change these to use anew macro 'EditExistingTenancy' but cannot see how to do it as when I right click now I only get a toolbar list.
Do I have to creat 2 new toolbar buttons?
How do I get rid of the non-functioning ones?
