I want to have a spread sheet where a user will pick an option from a drop down list, then based on that option choice, have a different cell populate with a specifc drop down menu.
Cell A1 has a drop down with three choices (1,2,3) User selects option 1 Cell B1 will now have a drop down with options A,B,C However: If user selects option 2 from A1 Cell B1 will now have a drop down menu with options X,Y,Z
I would like to make a form where the user has to select from a drop down list several options, and that depending on the pick the drop down list below shows different options. example: For the question "what food do you want to eat?" you can select pasta, pizza or dessert.
Now if that person pics dessert, the 2nd drop down menu should shom him again a number of desserts he has to pick. And again below another one depending on what he chose.
If I have a cell that uses a list for drop downs (ie "Make" can be any of several different Fire Alarm Panel Types) and a second cell that I want to use to represent "Model Number" is there an IF the model is A from the Make list, THEN the next cells drop down list represents the model numbers under that Make?
I have an excel sheet with Column H having drop down menus for each cell In the column, starting with H5 going downwards.
The drop-down menu contains around 50-70 options, and what I have to do manually is go to h5 and click on the drop-down menu and select the first value. I then go to h6 and click on the drop-down menu and select the second value. I then go to h7 and click on the drop-down menu and select the third value. I then go to h8 and click on the drop-down menu and select the fourth value.....and so on and so on.....until I have chosen all values in the drop down-menu!
Is there a macro that will just do this automatically? Starting with cell h5 get the first value of the drop down menu, go to h6 and get the second value of the drop-down menu and so on until all the values are chosen?
If you manage this one, I also need to do something similar for column K, but this time select the first value of the drop down menu for k5 AND k6, then get the second value of the drop down menu for k7 AND k8, then get the third value from the drop-down menu for k9 AND k10 and so on.
I am trying to create 4 pull down menus. Menus 1, 2, 3, 4. Menu 1 is the top menu, menu 2 will only show certain information based on what was chosen on menu 1. Menu 3 will show certain information based on what was chosen in 2 and 4, again, will only show certain information based on what was chosen in 3. Sort of how the menus on autotrader work, if you chose audi it will only show audi vehicles, although not for the same purpose, or even the same industry. I am using Excel 2007, it might matter. I have attached an xls file that shows the information I am using and below that the basic progression, I haven't listed it all, but you should get the general idea.
I have a very large database, filled with every job we're working on and all the details about it - duties, employees, vehicles, material-costs, etc.
I am currently working on a 1-page "Summary Sheet", that would be used to wade through all of this info and only give me the information I am looking for on one job. I would like to be able to provide drop-down menus on this "Summary Sheet" so that management can pick the information they'd like to see, and not be bombarded by everything else.
Ideally, what I am trying to do is to have a space on top where somebody could enter the name of the job, and then when they pick an item from the drop-down list, it would pull that info from the database via an "Index/Match". When somebody enters a job-name and picks "Joints Tested" from the drop-down, it will only display how many joints were tested on that job.
I already have the drop-downs created, and have other Index/Match formulas in other spreadsheets (they trip me up a bit, but I can generally fiddle with them until they work correctly), but can't figure out how to make it work this way. My database has headings above each column, and I'm writing those same headings next the different options in the drop-down list, but I can't figure it out.
I receive inspection sheets from mechanics and I need to start tracking trends. So, let's say the mechanic has marked an "interior" issue and of the 10 potential items that could related to "interior", he has chosen "dirty upholstery" -
Column A is drop down menu with four categories listed:
Interior Exterior Transmission Undercarriage
So in Column A from the drop down menu I pick the main category of Interior. Then it's on to Column B to choose the exact issue of the Interior. When I choose "Interior" in Column A I would like Column B to automatically show me another drop down list with issues that relate only to Interior (i.e. glass, dirty upholstery, torn upholstery, etc.)
that is question #1....
If there are multiple issues on one vehicle, I would then go to Column C, pick another category (i.e. Transmission) and then in Column D, I would like it to automatically display the drop down menu that relates to Tranmission issues (engine oil, air intake, engine wiring, etc.).
I am using the following code to create a custom command menu.
Sub AddMenus() Dim cMenu1 As CommandBarControl Dim cbMainMenuBar As CommandBar Dim iHelpMenu As Integer Dim cbcCustomMenu As CommandBarControl On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("&New Menu").Delete On Error Goto 0 Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")..........................
I want to add a new button control at the bottom of the menu underneath the holiday control but it keeps adding it on the sub menu, which leads off the holiday button control. I want the menu to look like this.
Open Net 2 Access Add Employee Edit Employee Delete Employee Holidays (3 options on sub menu) *New Control
there is some clever code to create a customized menu in a dynamic Add-Ins section of the Excel ribbon; this section disappears when the workbook is deactivated and re-appears when it is activated. The custom menu has 2 main items each of which can launch a macro. There is also a 3rd main item called "Next Menu" which cascades nicely to a sub-menu. That sub-menu can have several items of its own. Very cool code.
However, I am trying to add a 4th item in the main menu, say, "Next Menu2" which also cascades to a sub-menu. The problem I'm having is when I try to replicate this code to accomplish this, "Next Menu2" appears in the sub-menu of "Next Menu", rather than as a separate (4th) main item below "Next Menu".
I believe there was another post (not sure of the date, but has since expired) which asked basically the same question as mine. There was a reply with code saying "This should work" but when I tried it, it didn't help.
I want to create a submenu to an already existing user defined menu.
After creating and saving the sub menu using Tools ->Customize ,it works fine. But when
I reopen the Excel sheet it is not found.
I could not find any macro related to the original User menu.Also this menu gets displayed after the AUTO OPen macro in my excel has worked. This menu gets displayed for only that workbook and not for others.
I have been trying to find out a way to create Sub menu for that ,but could not?
I am wanting VBA language in a macro that will move the cursor a certain number of cells in a certain direction. For example, I want the cursor to move right one cell, no PARTICULAR cell, just right one cell. Is there something I can use?
Is there a way to record the mouse movements within VBA. I essentially want to use excel to open an external program and execute specific commands within that program. Unfortunaetly the extrenal program is not a micorsoft program
I've made quite a few programs I use in excel and have wondered about this for awhile.
When you run a macro that selects cells and objects off screen or on other sheets, the screen moves to those places. Is there anyway to lock the sheet so this doesn't happen and things look a bit more professional ?
A good number of years ago I used a line of code at the beginning and the end of a macro to keep the spreadsheet from moving until the macro was finished. At the close it moved if a movement was necessary.
Is it possible to prevent a user from being able to move a userform around the screen area (clicking and holding caption bar)? I am captureing a image and using Pixels coordinates on the capture and need the userform to stay in the center of the screen or the image will not be catptured. The StartupPosition is center of screen, tried
I want to move the cursor in my spreadsheet from cell to cell in a particular order. I've tried the following code, but it only works when I change the value in the cell.
Private Sub Worksheet_Change(ByVal Target As Excel.Range) Select Case Target.Address() Case "$A$1" Range("$F$5").Select Case "$F$5" Range("$B$12").Select Case "$B$12" Range("$A$6").Select Case "$A$6" Range("$A$1").Select End Select End Sub
I want the cursor movement to follow the same order even when I don't change the cell value, for example, when I repeatedly hit the "Enter" key without altering the existing cell value.
I want to do a arrangement for a file like this " wherever cursor moves in excel that particular cell will highlight with color and once it goes to some other cell that last highlighted cell will come as a ordinary cell"
I've exhausted my search engine skills and I'm about 99.9% sure Excel is incapable. This message board has been great over the years of figuring out even the trickiest of problems, but is there any functionality in 2003 or the slight possibility that after a user inputs a number in a cell (no tab, no enter) that it will move to the next cell.
After reading about this, most people say it is not possible even with VBA or Macro, and I certainly believe it, but the whiny, and horrible department that I work for are curious if this is possible. So, is it? If this is the wrong area for this questions, I apologize, I was considering putting this in the Macro/VBA area, but I gave up in deciding where to post this.
I want to be able to enter a single digit figure into a cell and have the cursor move automatically to the next cell to the right. then enter a figure in there and have it do the same thing. is this possible and, if so, how?
I need a macro which will put "P" when the cursor will be moved by right arrow key in the range c19 to AG55 if the cells are blank suppose cursor is moved from c19 to c20 & if c20 is blank then "P" will come on, if c20 is not blank say "Z" is in c20,then at c20 "Z" will remain at c20 and the code will not put "P" at c20 then.
I need to change the way Exel move the focus when I press return in a cell. For example when I am in column 1 and press return, I want the focus to move to column 4. If I am on column 5 I need to go on the first column of the next line, etc ...
I think I am suppose to use ActiveCell.Offset(1,0), and ActiveCell.Offset(-4,1) for my 2 examples. But my question is what is the VBA code for: "do that when I press enter and I am in this column"?