Creating A Selectable Menu
Apr 14, 2009
I am attempting to create a Menu (food) in Excel 2007. I have a list of foods that I would like to select once one is selected the next list would be for the next item and so on. I know how to create a drop down list but once I select an Item
I would like the next list to narrow down the field (or choices). I am not sure I explained this well enough so here is another way to put it.
First Column would be a choice of meats. Beef, Chicken, Pork, etc.
If you select say Beef the next column would be a veggie, Carrots, Peas, Green beans. But with Beef you cannot select Carrots. and so on.
View 4 Replies
ADVERTISEMENT
Oct 18, 2008
I am using the following code to build and remove a menu on the menu bar. how to modify this to create sub menu's instead of a single drop down list
View 2 Replies
View Related
May 3, 2006
How do I create drop down menus in a spreadsheet?
View 4 Replies
View Related
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
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
Feb 28, 2008
i want to create a menu in the worksheet named "Main Menu" that lists all the other worksheets within the workbook with the option to select the required worksheet and view or print it.
View 7 Replies
View Related
Jun 17, 2011
I am trying to create a "mainmenu". On a Userform using API calls.
Created a Userform and named it Form1.
Added a command button to the form and named it Command1.
In THISWORKBOOK code:
Private Sub Workbook_Open()
Form1.Show
End Sub
[Code] .........
I open the file and Form1 is shown with its command button. When I click the command button I get an error:
Run-time error 49:
Bad DLL calling convention.
What is the correct convention?
View 4 Replies
View Related
Dec 6, 2006
I have created a list in a Microsoft Excel Workbook (names and corresponding numbers) and named the list.
Then, I created a drop-down menu through Data/Validate/List that included the names.
I can look the names up in the drop-down box, but I would like to be able to type a few letters and Excel auto complete the rest of the name. For instance I would type Ja...and James Doe would come up with the mes Doe in black (highlighted).
Is there a way to do this in Excel?
View 9 Replies
View Related
May 29, 2007
I have a workbook that creates three temporary menu buttons when I open it. These work fine until I try and open more then 1 workbook at a time. This creates duplicate menu buttons (3 times the number of workbooks that I open).
I call up the procedure when each workbook is opened using this code in the "ThisWorkbook" code area: ....
View 9 Replies
View Related
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
May 21, 2007
Can a list box (or other type) be created that would come up and allow a selection of multiple items. I do not need the items to be viewable beyond the selection, only to be ablle to sum different segments of the rows that were selected.
As example: Upon clicking in cell B 141 of the sheet a box would come up that would include the descriptions (in column C) of all items that are between rows 1 and 140 that have identifeid by a "y" in Column B. Then you could select as many as you desired and the sum of the quantity (column d) of the selected items would then appear in D141.
View 14 Replies
View Related
Sep 7, 2008
If I put data into one of two cells I want it so that the other cell cannot be selected. I can't say I've struggled with this for days as I really don't know where to start
View 9 Replies
View Related
Sep 18, 2009
I am trying to use the COUNTIF function but over a selectable range. in other words instead of a fixed range like =COUNTIF(A1:A11,"=yes") I want to be able to choose the range Axx:Axx selected by drop down menus.
View 3 Replies
View Related
Aug 7, 2007
If I create a pivot table, I'm able to click the arrow to the right on my row header, unselect "Show All" and then manually check boxes next to the rows I want to show. The pivot table then shows only the rows I'm interested in.
I can't figure out how to do this with filtering outside of the pivot table. I can select AutoFilter and then select "All", "Top 10" or individual rows, but I don't have the option to use a checkbox style selection to choose multiple, but not all, rows.
How can I set this up to have checkboxes associated with the AutoFilter dropdown so I can pick and choose which rows show?
View 9 Replies
View Related
Sep 9, 2009
I would just like to know if there is a way to add items to a drop down list that cant actually be selected.
Asking because I have a table from which the dropdown list gets populated and the user then selects a particular row but would like the header fields to also be added to the list just for reference.
I have attached the spreadsheet in question for reference.
View 2 Replies
View Related
Aug 10, 2006
I have a sheet with logged test data.
Various test items are stored in columns.
(First row of each column is the description of the test item)
Problem:
1) To reflect certain testdata in a chart I want to be able to select a different column (Y values) by means of a dropdownlist.
X values are just the number of items (1 to ...)
How to make the charts data source selectable?
2) It seems that the input range of a ddl should be a list of items.
In my case they are in the first row of each column so only the first item is shown.
View 5 Replies
View Related
May 29, 2009
I do data entry for a webstore and one cell is used to map out the exact product category/subcategory path. I currently have to copy the appropriate path from a long list on one page and then paste it into the cell. I have to do this a hundred times a day. It would be nice if each cell within that column can have these values stored in them so I can just click on the cell and open up a drag down box and select the needed value. Is this possible to do in Excel?
View 2 Replies
View Related
Nov 30, 2007
The following macro copies a range from "ThisWeek" worksheet to a selectable worksheet "Week1, Week2, Week3, etc. (determined by value in cell P13 (1,2,3,etc.)) The copy destination is currently cells F5:F36 but I want to make this range selectable also (ex. G5:G36, H5:H36, etc).
For example: If "ThisWeek" worksheet (fixed) cell $B$7 = "Adam", I want to match/lookup this name on row 4 (column F,G,H,etc) on the destination worksheet and copy the range of data to a column under the heading labeled "Adam". (No need to verify if heading exists)
Hope I have explained my problem clearly.
View 9 Replies
View Related
Apr 9, 2014
I have developed a user form in VBA which is used for entry into an excel worksheet. From this data, I need to do the following:
1) Create 2 output files for Job data entitled "J" and another file entitled "S". The "J" and "S" is captured in a field in the data. I need to hit a button that allows these 2 output files to be produced, so I need to 'loop' through rows of the data to do this/
2) In addition to 1), the user needs to be able to 'select' the date range they would like to see 'J' and 'S' data over. This will be based on a field called "Startdate'. How could I do this with the button above-can I parse an input value to a form and select the 'J' and 'S' files on this.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
Jun 21, 2007
I have made an excel addin named "INDNUMFOR" and want that this should display under "Data" of main menu bar. thus, a new item (sub menu) should appear naed "IndNumFor" under Data main menu.
View 9 Replies
View Related
Dec 22, 2008
I am trying to build a selection for a procedure to use.
View 2 Replies
View Related