List Not In Data Menu

Jun 4, 2006

Why is the List option not in my Data menu? Using Excel 2003. I want to be able to create a new list, this option is not available on the List toolbar.

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

Dropdown Menu With List And Custom Data Validation?

May 2, 2014

I have a Drop-Down Menu that looks like:

BOS
PIT
COL
NYR

using List with source =Lists!$B$2:$B$9, which is just the validation list

My Table:
Team Player
BOS Bergeron
BOS Krejci
NYR Nash
... ...

My goal is to limit the end user from choosing BOS more than two times from the drop down menu

View 4 Replies View Related

Chart Menu Bar Won't Change To Data Menu Bar

Apr 26, 2007

my worksheet menu bar is displaying the ' Chart' menu no matter what I do. Not only do I have no charts in the workbook, (verified this by: )

For Each ws In Worksheets

ws.Select
MsgBox ActiveSheet.ChartObjects.Count

Next ws

but adding worksheets, selecting various parts of a worksheet, creating a chart and deleting it, and everything else I've tried has no effect.

One interesting thing - the first chart I added (to test if it would 'unstick' itself upon deletion of the new chart) was named 'Chart 2', implying there was a chart1 that existed previously.... although I am fairly certain I never added a chart to this workbook at any point.

Also, the menu bar is working fine in other workbooks, and changes to chart and back to data like normal.

View 6 Replies View Related

Menu .Id Number List?

May 21, 2006

Is there a list with all the .Id number of menu items? I am wondering about this because if I use .Captions they will be different in English than, for example, in French and I'm afraid my code won't make sense anymore. Also, are the menu .Id numbers different for Mac-Os X Excel users to those using Windows?

View 2 Replies View Related

Dynamic Dropdown Menu / List

Aug 22, 2013

I have a successful dropdown menu that removes items that have already been selected through the dropdown list, however, I need it to be able to handle IDENTICAL items. At the moment, it can only handle unique items.

I'm trying to create a Rota Planner. I have a selection of shifts that need to be selected for each day. Some shifts are repeated (meaning that there may be 4 members of staff on the same shift). As ONE of each of the 4 shifts are selected, I then want only 3 to be displayed in the dropdown menu to be selected, until all of them have been selected.

I've tried to break apart the code that provides dynamic dropdown list for UNIQUE values but I'm tearing my hair out and getting nowhere.

View 4 Replies View Related

Menu List Ideas For Several Columns

Nov 5, 2009

need to create a simple list: simliar to how windows drivers appear Column A: (example A1= Make and Model#)

-then 5 columns based on which make/model is selected to appear

-only shows the selected printer's data

i'm having issues having rows in lists and using names in excel 2007.

-i have raw data but its very ugly when sharing... would like to basically:

a. select the item

b. have the item's data (several columns) show up

example:

select A1

then: B1, C1, D1, E1 and F1 appear

any ideas for a template or where to start?

View 8 Replies View Related

Add List As A Subchoice To A Custom Menu

Jun 2, 2006

I have create a custom menu and want to add a choice and a subchoice that will guide the user to insert a number in an inputbox or under a list. Then the user's selected number it will be used as parameter for a vba code.

Eg.:
The choice is: How many rows will be marked
The subchoice : 10 (default value)

What i want is the following:
If the user choose the above subchoice then it has to be appeared an inputbox or something like that in which he has to insert a number, eg. 45. After that the choice must shows

The choice: How many rows will be marked
The subchoice: 45

This parameter must be active all the time that the user uses the workbook. At the end, if the user saves the workbook, the next time it will be opened, the subchoice must have the value 45.

Look at the attachment image to see exactly what i want
Here's the code. Just copy it under a module

Option Explicit

Dim cbMenu As CommandBarControl
Dim cbSubMenu As CommandBarControl
Public MenuSeries

View 9 Replies View Related

Dropdown Menu From A List That Autofills Another Cell?

Aug 13, 2013

I want to select Work Type and it will then look at the list data and auto fill the highlight cells.

View 5 Replies View Related

Dropdown Menu To Pick Records Out Of List?

Dec 16, 2013

Is it possible on Excel to make a drop down menu which picks records out of a list?

I've a big spreadsheet. Thousands of records. About 100 responsible are listed responsible for them. I've highlighted stuff for them to fix, I'll be emailing it out to them, and they'll need to isolate the dozens of records they are each responsible for.

They are, erm, technologically challenged. I want to keep it simple, put one menu on the screen and say

'Pick your name from the list.'

George W picks himself, and then it lists his records but not anybody else's.

Can Excel do that? (Rather, probably, but where do I start?)

View 7 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

Replace Standard Shortcut Menu With Custom Menu?

Jun 24, 2014

I have created a sub to add new controls to the "Cell" shortcut menu. Can I remove the standard "Cell" shortcut menu controls? if so how do you do it?

[Code] ......

View 4 Replies View Related

Menu Bar/Navigation :: Tool That Creates A Menu Bar Or Code?

Oct 20, 2009

I have a workbook with multiple sheets. Is there a tool that creates a menu bar or code that I can add that would support navigation?

My goal is to have something with approximately 4 options (buttons?). They would link to 4 different sheets that serve as indexes within the workbook.

I know I can add a control like a button to a given sheet that would take the user to given sheet when clicked, but can I make the button 'float' above all the sheets, or add to a menu bar, or something? I just don't want to have to add the button to every sheet in the workbook.

I am looking for something simple/easy, and am not looking for anybody to do the work. I just have no idea on how to approach the problem.

View 11 Replies View Related

Menu Pathing (execute The Macro From Menu)

Jul 2, 2009

I'm adding a menu selection to the right-click menu that you get for cells. I can add and remove the menu option but, when I try to execute the macro tied to the menu, I get "the macro...cannot be found". I can't figure out what appears to be a "pathing problem". I'm sure it's simple but...

Here's the

View 4 Replies View Related

Window Menu In The Main Menu Bar Deleted

Mar 27, 2009

I have actually got the Window menu in the Main Menu Bar of excel deleted using below command.

Application.CommandBars("Worksheet Menu Bar").Controls("Window").Delete

View 9 Replies View Related

Menu Structure: Opens A Menu Next To It With Different Options

Jul 15, 2006

Now this is something which I dont even know if it can be done, but its something which I would use, a lot. When clicking on a button, like a normal button from the control toolbox, is it possible to open a menu from this? So I click on the button i made called "accounts" and this opens a menu next to it with different options.

View 5 Replies View Related

Counting Menu Items In Menu Bar

May 20, 2006

Suppose I delete a (unknown) number of items from the Worksheet Menu Bar. This can vary because of the fact that my excel sheet is being used by a different number of people, all with a different Worksheet Menu Bar configuration. Is there a way of counting how many Menu items are still left in the Worksheet Menu Bar?

So, suppose all that is left (after using the program) in the Worksheet Menu Bar are Excel, File, Tools, Help. How can the porgram find out that there are only 4 items in the menu?

View 3 Replies View Related

Sub-Menu Not Showing On Toolbar Menu

Jul 8, 2007

I am taking an EXCEL(online) class and in my current assignment i am to create a 'list' for sorting and querying. However i cannot find the 'list' option, under my DATA option on the toolbar. I have tried all my toolbars and shortcuts but I am unable to find it anywhere.

View 9 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

Dropdown Menu Data Validation?

Sep 12, 2012

I am trying to create a drop down menu in Excel to display certain values but it's not working. I want to input certain data in the cells. eg, 019, Quebec, Agent, Direct etc. I want to create a drop down list where if 019 is selected, all 019 entries would show up hiding all others. When nothing is selected all values would show up. I created a list but if I have 10 "Agent" entries in the cells, the drop down list also shows 10 "Agent entries rather than letting me select "Agent" and then displaying all agent entries below. I don't know if it makes sense but I basically want to make it easier for people to look for certain entries that they need rather than going through the entire spreadsheet to find all 019's.

View 2 Replies View Related

Retrieve Dropdown Menu Data Using VBA

Jun 21, 2014

Most of the information I need I am getting using standard web queries. But pulling data directly from drop down menus seems beyond the capabilities of a regular web query.

I only need the information that shows as the menu options. I don't need any information from the pages at those links. Nor do I need the links.

Actually all I really need is the option value information, and the date. So for the first item, I would be looking for, 7|2014|u 06/18/2014

View 3 Replies View Related

Creating Dropdown Menu For Data Extraction

Nov 30, 2012

Creating a drop down menu that allows me to pull data from sheet2.

I have all of my data on sheet2 and my objective is to have a small portion of the data displayed on sheet1 once the user selects the specific "study" from a drop down menu.

how to create a drop down menu that will have a list of all the different studies, and then once the specific study is selected, how do I make it display the pertaining information in the master sheet.

Follow up....more information

The data I’m working with is a master list of different drug studies. All of the data is broken down by the specific study itself, so all I need to do is figure out a way to let the user access the data in a quick and easy way. I figured this could be down with a drop down menu that has a list of each study, and the user could select the study they want to review. Once selected, the data pertaining to the study would then populate the fields on the master silde(sheet1).

View 9 Replies View Related

Data Transfer From One Worksheet To Another Using Dropdown Menu?

Sep 29, 2013

I have a table with 150 or so Job Titles down the first column. Across the top row, I have 25 or so courses listed. There are Xs in the table indicating which courses are required for each job title.

This worksheet is intended to be used by individuals who will look up their job title to see which courses they must take. My goal is to simplify this process. I would like to create a worksheet in this workbook which has a drop down list of job titles. When the title is selected the data will transfer to a table on this new worksheet.

I've attached the spreadsheet I have and it's pretty self explanatory.

View 4 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

Populate Data Based On Dropdown Menu?

May 14, 2013

I have a list of staff in cell A1 in a drop down list. In cell A2, I would like Excel to populate automatically the branch from which the staff is from when I choose the staff name in cell A1.

View 3 Replies View Related

Using Dropdown Menu To Filter And Rank Off Raw Data Sheet?

Jun 19, 2013

I have one worksheet that has a list of accounts with various attributes. On a separate worksheet within the file I would like to have a drop down menu to select one attribute (i.e. category) and then once selected, have ALL the accounts with that attribute populate in a descending order based on another attribute (i.e. volume).

View 2 Replies View Related

Show A Certain Cell Depending On Data From A Drop Down Menu.

Jan 2, 2009

I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.

I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.

I can imagine that this is hard to picture so i have attached the file as well.

View 13 Replies View Related

Data Validation / Drop Down Menu With Paste Special

Jan 18, 2009

I know how to use the copy and paste special to copy a formula from one row down many rows in that same column. When I do this the formula will automatically change by 1 number {such as =IF(ISBLANK(C5),"",VLOOKUP($C5,Sheet1! $B$3:D4891,3,FALSE)) then when I click on copy and pasted special each following row will change by one number ---- to =IF(ISBLANK(C6),"",VLOOKUP($C6,Sheet1!$B$3:D4892,3,FALSE))

Can this also be done if the row you want to copy and paste is a row with data validation / a drop down menu? I simply tried using the same process for a row that has data validation the row with the validation has for the source =INDIRECT($B$5)

Is there a way to copy this down about 20 rows and have the ($B$5) change in each row by one number {such as ($B$6 THEN $B$7, ETC...) Or do I just have to do the whole data validation process for each row?

View 3 Replies View Related

Data Validation - Creating Dropdown Menu With Values

Feb 2, 2013

I have a list of values (say a, b, c, d, e) and creating a drop down menu with these values in say A1. Say I chose 'c'. Now in cell A2 I want to be able to choose from the same list without being able to choose 'c' again. In cell A3 I want to be able to choose from the same list without being able to choose the values lalready chosen in A1 and A2. and so on.

View 2 Replies View Related

Submit Options From Dropdown Menu And Get Data From Website

May 26, 2014

I am trying to get data from this site in excel. I need to select options from drop down menu (like bank name, balance sheet and date).

View 5 Replies View Related







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