Conditional Combo Box And Graph
Jun 3, 2006
I'm making a report that graphs some day to day data, and I want the user to be able to either select the specific month or week that he wants on the graph. This leaves me with two questions. First of all, I have a list box with the option to select by month or by week, how can I make it so if month is selected, a list of months come up in the combo box and if weeks is selected, the weeks will?
Second, how can I have the X-axis of the graph adjust accordingly for a week or month graph? One idea I had would be to actually make two graphs in the same spot, and have the appropriate one display through VB, which I do not have the knowledge to do, but seems possible and not too complicated. I'm sure i'll need VB for both of these issues and though I think I know what I need to do, I do not know how to code it.
View 3 Replies
ADVERTISEMENT
Jun 24, 2008
I currently have a spreadsheet with about 30 graphs, and when I am done there is going to be about double that.
I want to make one sheet, with a combo box that allows me to select which graph to display, so that users don't have to cycle through a large number of tabs.
I have seen this done before, but can't figure out how to do it. The extent of what I know is making a combo box and selecting the data range for the options to select in the combo box.
View 10 Replies
View Related
Oct 23, 2007
I have a table which provides the source data for a Bar Chart style graph. I need the colour of the different Bars to change depending on the values in the table. For example. If the value is over 1% then the bar will change to the colour Red otherwise it will stay Green.
View 3 Replies
View Related
Sep 19, 2009
I want to make a combo box in excel that, if i select it the sheet inside the combo box will appear.
Example:
Inside of combox are: Sheet1
Sheet2
Sheet3
If i click combo box and i choose sheet3 the sheet3 will appear.
How can i do this? theirs a macro code to use?
View 9 Replies
View Related
Oct 9, 2008
The first combo box is on a userform so that a subject can be selected
View 3 Replies
View Related
Mar 21, 2014
I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.
View 7 Replies
View Related
Jun 11, 2006
How can i make a graph that will graph against time? lets say i have a bank balance like this:
1/2/2000 $500
1/3/2000 $600
3/12/2000 $400
there may be more than one entry on any one given day, or there may not be an entry for 2 weeks. How can i graph the running balance in a way that it will show the timeline just as a calendar year(or however long i selected) and the points are plotting according to their date, not just equally spaced out.
View 2 Replies
View Related
Oct 19, 2008
I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.
For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.
View 6 Replies
View Related
Dec 30, 2008
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.
A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg
Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):
Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).
View 2 Replies
View Related
Feb 1, 2007
I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.
View 2 Replies
View Related
Oct 15, 2008
I have used and adapted the following code for my sheet:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=824
But this combo-box only appears when I change from and back to the first sheet. I would like to either let the combobox appear
-when I open the file or
-when I click anywhere in the first sheet (can be a specific cell, or not)
Another solution would be to "fix" the combobox to a specific cell, ie not make it pop up anymore but just have it there.
View 5 Replies
View Related
Oct 23, 2009
I am having a few problems trying to amend the code so that it only uses the text box and combo box below. Unfortunately I am having a few problems. I am new and have amended this spreadsheet / code from another user on this site.
When I delete the combo box on the right, using developer mode, a run time error occurs.
View 2 Replies
View Related
Mar 16, 2007
I've got a worksheet which uses comboboxes at certain points for users to input data. At other points in the sheet they are entering directly into cells.
I've got the sheet protected, with the input cells unlocked so that it is possible to jump to them using the tab key.
However, I can't seem to make the tab key jump to any of the comboboxes. Ideally I'd like to set the full order for the tab key so that it jumps between input cells and comboboxes at the required stage.
View 13 Replies
View Related
Jul 9, 2009
I am trying to set-up a database where a list of people are trained on different items of equipment.
Is there anyway of doing this example please?
John is selected from a drop down box.
If he is trained on certain equipment, the box will turn green automatically. If he is not, the box will be red.
I am assuming, I will have a separate sheet housing all the names and what areas they are trained in.
View 9 Replies
View Related
Dec 13, 2012
I have a problem where a combo box in a form won't populate from the VBA code in the initialise routine. I've tried a couple of difference methods for populating the combo box without success. The code I have is:
VB:
Option Explicit
Sub NewTender()
Application.ScreenUpdating = False
[Code].....
I tried the excel file uploaded by Norie but it only displayed "Is". Are there any settings I need to modify to allow the add item property to work?
View 2 Replies
View Related
Jun 4, 2009
I added a combo box to a worksheet and closed and saved it. But I don't want it amymore. I cannot delete it. I try right clicking it but nothing. The worksheet,(workbook) isn't protected.
View 2 Replies
View Related
Sep 22, 2009
-To have the text alignment as centered; and
-Have a shading in it (as per the row)
I have attached a spreadsheet so you know what I mean.
For instance the row in which the combo exists, is shaded blue, is there a way to make the box the same shading too?
View 3 Replies
View Related
Dec 30, 2006
I have 8 combo boxes on Sheet 1, which must contain the info from Sheet 2.
The "Group" Combo boxes should contain the letter of the group (A, B, C or D - the information should be used from the D2:D5 cells from Sheet 2).
I want when user clicks on the Group Combo box (the one on the "1st Grade" row for example), and select some group (for example A), in the left combo box (which at first says "Choose Group ..."), all the names of studenst from 1st Grade and A group to be displayed.
View 12 Replies
View Related
Mar 11, 2009
How do I clear all combobox at one time? Now i am clearing it one by one and i forsee that if i have alot of combobox, this list will go a long way.
View 5 Replies
View Related
Jun 4, 2009
I am loading my UF combo box based on data in one of my sheets. I want in a way that if I keep adding to my data sheet, it would add with it.
For some reason it is not loading as I wanted to. I have tried as module and as UF code. Again, for some reason it is not loading.
Here is my code
View 7 Replies
View Related
Sep 14, 2009
How do I refer to a combo box (form control) in a calculation. EG: how can i say if comboBox = Something then ....
View 5 Replies
View Related
Oct 9, 2009
how to use a combo box to select hyperlinks to take you off to the selected website? I have this, which works but it's hard-coded - I'm looking for something a little more dynamic, i.e. pick up hyperlinks from a range on a sheet.
View 2 Replies
View Related
Jun 7, 2006
I have some problem making one Combo Box in excel to be populated by data from a closed workbook.
View 9 Replies
View Related
Jan 10, 2007
I have a form with a combo box. Is there a way, if a user enters something not one of the current choices, to have that choice added to the list?
View 9 Replies
View Related
Apr 6, 2008
I have a combo box(form control) and have it populated with data.
I want each item to do something so that when one is selected it triggers and event.
the items are:
Rounds 1 - 5
Rounds 6 - 10
Rounds 11 - 15...just like that all the way to 30
the worksheets are labeled "Rd 1", "Rd 2", "Rd 3" ...etc
When I click "Rounds 1 - 5" in the combo box, besides the "Summary" worksheet (which is where the combo box resides) only "Rd 1 - Rd 5" should be visible, I want all other sheets hidden, and when I click "Rounds 6 - 10" I want "Rd 6 - Rd 10" visible and all else hidden.
View 9 Replies
View Related
Jul 20, 2008
I've been mucking around and wondered if it possible to hide a row that has a combo box in it, that when I hide the row the combo box will be hidden to as well and if the row gets unhidden it should also unhide the combo box?
View 9 Replies
View Related
Jul 22, 2008
Private Sub Vendor_Combo_AfterUpdate()
Pricing_TB = Application.WorksheetFunction.VLookup(Vendor_Combo, Range("Del_ID"), 5, 0)
End Sub
I am trying to populate a TB in a user form with the value selected in the combo box. but it is failing as soon as I click on the Vendor_combo box and I am not sure why, as it is set to do the vlookup after update.
View 9 Replies
View Related
Aug 12, 2008
I am trying to add a combo box to a cell, passing in a variable called testerName from a listbox in a form. I can get it to work by just creating a combo box that displays on a sheet but I want it inside a cell. I think I'm reasonably close ....
View 9 Replies
View Related
Oct 13, 2008
I have a combo box in a report that currently updates using this code.
Sub popcombo_Initialize()
With Sheet1.ComboBox1
.AddItem "Budget Card"
.AddItem "Car Insurance"
.AddItem "Charge Card"
.AddItem "Credit Card"
.AddItem "FRS"
.AddItem "Home Insurance"
.AddItem "ISA"
.AddItem "Life"
.AddItem "Other"
.AddItem "Pension"
.AddItem "PEP"
.AddItem "Personal Loan"
.AddItem "Personal Reserve"
.AddItem "Pet Insurance"
.AddItem "Savings Protection Plan"
.AddItem "Travel Insurance"
.AddItem "Travel Money"
.AddItem "Unit Trust"
.AddItem "Wedding Insurance"
End With
End Sub
But some items on this list are missing from month to month and don't need to be included for selection so I need a more advanced version of this that populates from a list in data.
Is there a way for it to look at a column in a data range containing month, then look at the column containing Product and take a definitive list of all products that match a certain month?? So Credit card might be mentioned 300 times for the month of september but it appears only once in the combobox?
View 9 Replies
View Related
May 18, 2009
I have a list box with a list of text. What i want is if the user selects one of these text values in the list it opens up a user form.
View 9 Replies
View Related
