Different Controls Set Using A Drop-down Menu/combo Box?

Jul 5, 2006

I am building an excel application that will allow the users to tick boxes which acknowledge completition of tasks. I then count up all the tickboxes to give them a score. However, I want to have multiple modes, so users can have different sets of tickboxes. Ideally, I would have a drop-down menu/ combo box at the top of the page with the 4 modes in, and then when selected the appropriate tick-boxes are shown. I considered creating 4 tickboxes in every location, and just showing them (object.hide/.show) when the option was selected in the combo box. I am currently using Excel Form Tickboxes, and counting themall, but if I did this method I would need to count them for each mode. would I need an array?

View 2 Replies


ADVERTISEMENT

Drop Down Menu: Add Another Selection To The Menu List

Oct 18, 2008

I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..

View 3 Replies View Related

Set Combo Box Controls To 1st Item

Aug 9, 2007

I have a couple of combo boxes. I want to use a macro to control them: when I run the macro, all the combo boxes select the first item in the drop down list. My code is:

Sub test()
ComboBox1.ListIndex = 0
End Sub

run-time error 424, object required.

View 4 Replies View Related

Add Controls To Right Click Menu Based On Range List

Sep 28, 2007

I have customised the right click menu's for this spreadsheet and currently it is all hard coded. I was wondering if it is possible to dynamically modify the right click menu? The code currently has right click buttons for each staff member, and when clicked other actions are performed. I have added a "Staff" sheet and was wondering if there is a way the code can reference that sheet and create the list based on those entries for example, when new staff join or other staff leave?

I'm sure that there is a better way to go about this, perhaps a For... Next loop but I don't know enough about it. In the mean time, I will keep bashing away at it in hopes of a brainwave... it's a Friday before a long weekend and I think my brain has decided its holiday time.

Option Explicit
Private Sub Workbook_Deactivate()
On Error Resume Next
With Application
. CommandBars("Cell").Controls("Add Nick").Delete
.CommandBars("Cell").Controls("Add Toby").Delete
.CommandBars("Cell").Controls("Add Ben").Delete
.CommandBars("Cell").Controls("Add Matt").Delete
.CommandBars("Cell").Controls("Add Zoe").Delete
.CommandBars("Cell").Controls("Add Anne").Delete
.CommandBars("Cell").Controls("Add Craig").Delete
.CommandBars("Cell").Controls("Add Unknown (1)").Delete
.CommandBars("Cell").Controls("Add Unknown (2)").Delete
.CommandBars("Cell").Controls("Remove").Delete
End With
With Application
.CommandBars("Cell").Controls("Cut").Visible = True
.CommandBars("Cell").Controls("Copy").Visible = True...............................

View 2 Replies View Related

Drop Down Or Combo Box Instead Of Input Box

Jan 25, 2010

I currently have the following user inputbox that asks the user to enter the company name, of which it then copies the entered name to Cell E1 on the active sheet

Dim strName As String
strName = InputBox(Prompt:="You name please.", _
Title:="COMPANY NAME", Default:="Enter Company Name")
Range("E1") = strName

However, I would prefer it if there was a drop down list to select one of five pre-set company names without having the user to type the name out every time.

View 4 Replies View Related

Drop Down List Using A Combo Box

Mar 27, 2009

Trying to create a drop down list using a combo box. Then, when i select an item on that list, it will bring me to the range of cells where that information is stored.

Is that possible? I have no VBA experiance at all.

View 9 Replies View Related

More Drop Down Menu

Jan 7, 2009

I can weld together a bare chassis, or a complete turn-key car, or anything in between. With that I am putting prices next to every option, and part n piece that goes on the chassis. This is fine when I choose welded chassis under car type and just add a few options to it.

However if I choose turn-key or even roller, there are items that i need to choose between like rear coilover manufacturer and what not, but I dont need to add that price in considering its already included in the turn-key price of $135,000.00

So my question is, if I choose bare chassis, can I leave everything the same, but if I select turn-key, can I make it so it does not include that price in the bottom total cost of the car?

View 3 Replies View Related

Drop Down Combo Box List On Type

Feb 17, 2009

Leith was kind enough to to put a great combo box together for me (see attached). Is it possible for the drop down list to open on type or do you always have to click the arrow?

View 3 Replies View Related

Get X To Appear In Cell From A Drop-down Menu?

Jan 5, 2014

Looking to get a "X" to appear in appropriate box "in leave request form tab, cell M14, modified PTO box" that corresponds with correct selection from drop-down menu "in leave calendar tab, cell K6"... if i select "modified PTO from the drop down selection in K6, i would like to see a ""X" appear in "leave request tab, cell M14", then i can apply the formula to the rest of the selections in the drop -down...

View 5 Replies View Related

Make Drop Down Menu

Feb 28, 2007

how to create a drop down menu and grab data from the other side. pls have a look for a while at my attachment to check it...has anybody can provide me the steps

View 12 Replies View Related

Add Totals Via Drop Down Menu

Jan 15, 2009

I'm looking for cell j3 to add up al the things in row 3 so in the attached case it will come to £3.00 ....

View 9 Replies View Related

If Statment Using Drop Down Menu

Apr 7, 2009

I have another question with my red sox scores excel sheet. On my overview I want to be able to select any team, and view the indiviual stats against them. For the life of me I dont' know/can't find how to even do a simple yes no if statment to what the value in the drop down menu box is.

View 3 Replies View Related

How To Recalculate With Drop Down Menu

Jul 30, 2009

I want to make a drop down menu whereby each choice in the drop down would re-calculate my workbook.

Let me explain:-

I want to make a drop down menu in sheet 1 with 3 choices.
The 3 choices come from sheet 2 (row 1, column A, B, C).
I have data in sheet 2 in rows 2 through to 6 in columns A, B, C.
I have sheet 3 that currently uses the data from sheet 2 row 2 through to 6 for column A.

I want to be able to use the drop down menu in sheet 1 to choose either column A, B, or C in sheet 2 and then re-calculate the data in sheet 3 accordling.

I have the drop down menu made now.... but how can i re-calculate the values in sheet 3 after choosing a choice in the drop down?

View 9 Replies View Related

Resetting Drop Menu's

Nov 1, 2009

If I change the country in cell B2, I would like to have that the cells D2, E2 and F2 show the same name as cell R2. (This is always the first option of the drop menu's)

Cells D2, E2 and F2 are made by using the validate option in order to get drop down menu's.

The source information is in the hidden columns I-Z.

So for example:
if I change cell B2 to Belgium, I would like to see that D2, E2 and F2 also show Belgium immediately. I can then select the place I want to move from Belgium to by using the drop menu in D2 (for exampla Belarus).

As I selected for D2 Belarus, this has to be shown in E2 and F2 also.
I can now select E2 (for example Austria).

If Austria is selected in E2, I want to see this also in F2.

To recapitulate:
If I select Belgium as starting place, I want to see in movement 1,2 and 3 also Belgium, as there hasn't been anymovement yet.

If I let my army go from Belgium to Belarus, I want to see for the two remaining movements Belarus (as this means that the army remains in Belarus)
If I let my army go forward after Belarus to Austria, I want to see in the last movement phase Austria (no movement). If I still want my army to move I can still adapt it.

View 2 Replies View Related

Functions Using A Drop Down Menu

Dec 10, 2008

I've attached the xlsx file with this post. Now I've created a drop down menu with the 3 values I want to choose from. These values refer to the table situated directly above the drop down menu. Basically, in the end I need to calculate a 'Throughput' value which is supposed to depend on what I choose in the drop down menu.

For instance, if I choose 'Paddy' in the drop down menu, I want the corresponding bulk density and velocity values selected (same row). Similarly for the adjacent table, if I choose model 400/180 in the drop down menu, I would like the corresponding bucket capacity to be selected. I know my question is rather lengthy, but I'm sure the solution is rather concise. I just can't seem to remember or search for the solution!

View 2 Replies View Related

Drop Down Menu Values

Jan 7, 2009

I have setup a worksheet with multiple drop down menu's, all with different available options to choose from. If I go to the 1st drop menu and select say option 2, is there a way I can assign a dollar value to option 2 so that when I select that option, it posts the dollar value next to the drop menu? Then go to the 2nd drop menu select say option 4 or whatever, and do the same with the value.

That way at the end of the list of drop menu's I have a total of what the options that I have chosen for this particular piece to have and have a running total of what it costs?

To get the drop menu's I just listed a bunch of options for question 1, then went to data, validation, list, and selected those options. Then did the same and so on for other options.

View 7 Replies View Related

Drop Down Menu From Another Sheet

Nov 29, 2006

I do a lot of horse racing ratings in Excel, in fact its the only way I do the form these days.

The thing is I'm always looking for ways to save time and was thinking the other day about how I enter the results.

I would like to have "drop down menus" for each of the place getters that I get from another sheet in the workbook.

Is there a way to do this? I'm using excel 2007 (which I love)

Race 1 sheet is named race1 and have up to 24 horses/names to pick from

View 9 Replies View Related

Creating Drop Down Menu

May 3, 2006

How do I create drop down menus in a spreadsheet?

View 4 Replies View Related

Combo Box With A Yes Or No Drop But How Do You Make The Y A Default Always Entered

Dec 16, 2009

How do you make a Yes No combo box always have the default answer as Yes appearing on a user form but still allow the user to change it to NO?

View 9 Replies View Related

Drop Down Menu That Allows To Pick Any Team

Apr 11, 2009

I’m trying to do now is I have a drop down menu that allows me to pick any team that we can face in the season. Once that is chosen what I want to show is the individual stats against that team. Now right now I’m just trying to work out the formula to see if it works.

The formula itself is half working. For some reason some of the selections aren’t showing up like there suppose to do.

View 10 Replies View Related

Data Validation For Drop Down Menu?

Apr 22, 2009

I am doing an internship in Germany, and I have this crazy project with Excel. I am not very familiar with all the equations.

I want to select a company name and a type of container from a drop down menu, and have the information show up on a different sheet assigned for that specific company for the right size container. It involves quantities.

I will attach what I have sofar.

Ladungstraeger(1).xlsx

Ladungstraeger(2).xls

View 6 Replies View Related

Creating Personal Menu Drop Down

Jul 29, 2009

I have some code to create a personal menu drop down to execute macros, which is a follows:

View 2 Replies View Related

Select Macro From A Drop-down Menu

Apr 16, 2009

I have several pre-configured macros that I would like to choose from using a drop-down menu. I know this is possible within the excel built-in ribbon, but I need to have it only in the spreadsheet. The macro will be importing a csv file. I have several different csv files that I need to be able to choose from and a drop-down list seems to be the best choice. The other option could be to have the macro prompt me to select the csv file of choice. Below is a sample of the macro that I would be using. Is this possible?

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;P:A Harvest of HealthImportVendorsA-N.txt", Destination:=Range( _
"$N$1"))
.Name = "A-N_7"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells

View 9 Replies View Related

Drop-down Menu With All Sheet Names

Sep 21, 2006

What I am trying to do is to put a drop-down menu in a sheet which has all the names of the sheets that start with A, C and P?

Does anyone know how I would go about this?

View 9 Replies View Related

Add Drop List Box Or Combo Box In Yearly Time Sheet

Aug 1, 2009

how to add drop list box or combo box in this yearly time sheet so every employee has his own record in this time sheet so when ever i select name from drop list all info changed, i did include table in sheet 1 as an example.

View 4 Replies View Related

Drop Down Menu Based On Vlookup Results?

Feb 2, 2013

im trying to create a drop down menu that changes depending on the results of a vlookup. example: I have a vlookup function that populates a field with a product name based on the part number, however in some cases there are multiple products with the same part number. is there a way to create a drop down menu that contains all the product names shared by the same part number based on the part number that was entered?

View 1 Replies View Related

Data Validation / Drop Menu With Hyperlinks?

Sep 20, 2007

I need to put together a report for work.

What I want to do is this:

Create a drop menu. The options within the drop menu to be links (either to another Excel worksheet within the same workbook, or a WORD document).

I know how to create a drop menu, that is simple, but am not sure how to do the hyperlink aspect.

It seems when I actually insert>hyperlink onto the actual text of the drop menu (on the other sheet where i created the drop menu data), the hyperlink is not active in the actual drop menu itself.

View 2 Replies View Related

Don't Display Blank Entries In Drop Down Menu

May 10, 2007

If i make the listfillrange of my combobox a named range, is there a setting in the combobox that allows it to ignore any blank cells in the named range.

Lets say my named range is cells A1:A5 but only A1 has a value, the rest are blank.

The combobox drop down menu will display the value of cell A1 and then 4 blank rows. Can i make the combobox igoner the blank rows and only display cells A1 in the drop down menu?

View 9 Replies View Related

Multiple Drop Down Menu To Calculate A Percentage

Nov 6, 2008

I have a bunch of cells that use a drop down menu validation from a different set of cells so

Legend (this are in cells $A$7:$A$11)
NA - Not Applicable
0 - Not attempted
1 - Not Yet Competant
2 - Satisfactory
3 - Exceedes Expectations

Other cells have Data Validation using Allow List =$A$7:$A$11 to make the drop down menu option appear. What I would like to do is add a 'hidden number' on cells A8:A11 (A8=0, A9=1, A10=2, A11=3) A7, being NA isn't included in the formula I want to set up.

In cells later on I'd like to make a formula that takes those 'hidden numbers' into account and works out an average. So 'hidden number' / 'potential total' and make the cell display as a percentage, the 'potential total would have to take into consideration that a value has been set, but not use that value, and times the number of values set by three.

View 10 Replies View Related

Show Current Selection In Drop Down Menu

May 4, 2009

Hi guys i am in assistance of your brilliant brains, i have a working drop down menu which when selected i can select my data range such as below: ...

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved