Combine Two Macros For Dropdown Boxes

Feb 25, 2014

I have a spreadsheet I use to track reprimands for our employees. Reprimand Counseling Spreadsheet Example.xlsm. Previously, I had to read the entire reprimand in order to determine the policy violation(s) and then manually enter those reasons into the cell. We have a new standardized form, where the manger selects the reason(s) for the reprimand. I wanted a drop down box that I could select multiple reasons for the reprimand and have all the reasons appear on the same line, as well as being able to remove a reason from the line by selecting it again (so I wouldn't have to start over, in case I selected the wrong reason). I was able to find this code, on [URL] .... to accomplish that.

Same Cell Add & Remove

I also need to be able to manual edit some of the reasons. For example "Missed Meal Period(s) #___". I will need to be able to edit that item to read "Missed Meal Period(s) #2". I was able to find this code, on the same website as the previous code, to accomplish that. However, this code includes a line break, which I do not want.

Edit Same Cell

[Code] .....

Since I need the code to work on each worksheet (CIVI - SOCR), will I have to enter the code on each worksheet or is there a better way to accomplish this? Is there a way to combine these two codes, while simultaneously removing the line break? I need to select multiple reprimand reasons in the same cell and edit the reasons, if necessary. I've read and reread that article for hours, but I can't get it to work.

View 14 Replies


ADVERTISEMENT

Macros Untick Boxes As Well Reset Drop Down Menus

Jan 17, 2009

I am wondering how to create a macro that will untick boxes as well reset drop down menus.

View 9 Replies View Related

Reset Multiple Dropdown Boxes

Apr 3, 2007

I have dropdown boxes in cells B11,B14,B17,B20,B26,B29,B32,B41,B44 of my worksheet. I would like to use a command button that can reset all dropdown values to blank.

View 9 Replies View Related

Code For Button That Runs Macros Dependent Upon Which Boxes Are Checked?

May 16, 2014

See attached file illustrating exactly what I'm trying to do.

I won't repeat the exact same things I wrote in the file, but the Summary is that I need to first make such that only certain check boxes can checked at any one time, then make the command button run certain macro(s) depending on which boxes are checked.

View 8 Replies View Related

Hide Combo Boxes (dropdown List)?

Nov 14, 2008

I trying to do a sheet with one combo box (dropdown list) where I want the user to be able to choose "add rows" to make more boxes appear. My idea to solve this was to put all the boxes in the sheet, and then create a macro that either hides or shows the rows with the extra boxes. Now I have a problem that hiding the rows just does that, and only that. The rows disappear, but the combo boxes stay visible (but ends up on top of eachother).

View 2 Replies View Related

Multiple Conditional (Dynamic) Dropdown Boxes

Jun 5, 2014

I'm trying to incorporate multiple conditional (Dynamic?) drop down boxes to enable me to get an appropriate code at the end of the process. This will be used to product data entry and the code will tell Amazon where to post the product. I have many thousands of codes that i need to access and the easiest and most accurate way is to break down everything in to category and sub categories until I eventually get the code I want for that specific product.

for Example:

1730708031Clothing/Baby/Baby Girls 0-24m/Hoodies & Tracksuits/Tracksuit Bottoms

To return this code I would want to select Clothing, which returns a list which includes baby which in turn will give me a list that includes baby girls and so on and so on until I can select Tracksuit bottoms that will return the code.

Each list is dependent on the previous choice

As I have thousand and thousand of potential codes creating range list for each potential category and sub categories is not really feasible and would be very difficult to maintain when changes occur.

With this in mind I have created a code list that breaks the above example so that each category is now in it's own cell and there can be upto 8 (as I've seen so far) potential conditional categories before you return the code and ideally I would like to use this as it very easy to create and update. (see attached)

I might be able to use filters to return the appropriate list each time but don't know where to begin.

ClothingCodes.xlsx

View 4 Replies View Related

Selecting/changing Multiple Dropdown Boxes At Once

Feb 20, 2008

I'm working with Excel 2002 on Windows XP.

I want to select more than one drop down box at the same time, and copy them as well as rename the cells they refer to.

For example: in A1 there will be a box with LinkedCell set to A1 and ListFillRange set to B1:B5. I now want a similar box in A2, with A2 as LinkedCell. However, when I copy past the box in A1, it still refers to A1 and B1:B5 (the last part is ok). I can easily change A1 to A2 by just changing it in the properties, but the thing is that I also need these boxes in A3:A100. Is there any faster way of changing this?

Also, the ListFillRange might expand in the future. Therefor I would like to know if its possible to select the boxes in A1:A100 and change the ListFillRange to B1:B6 for all at once.

View 9 Replies View Related

Summing Lookup Data From Dropdown Boxes

Apr 1, 2007

How do you sum data from several cells that derive there answer from a lookup formula that is base on a selection from a drop down menu in another cell. The 6 drop down cells have the same ten items to choose from. Once those items have been chosen I am trying to summarize those six cells to ge a total for each of the item chosen.

View 9 Replies View Related

Auto Populate Multiple Dropdown Boxes

Apr 3, 2007

I have 3 dropdown boxes I created using the control toolbox which pull corresponding information from 3 different columns. I would like to be able to format them so that upon data entry in the first dropdown box, the subsequent two boxes auto populate with the corresponding data. Currently I have to select the information for each dropdown box manually.

View 6 Replies View Related

How To Combine 2 Macros

Mar 14, 2009

I probably have a odd request, but then I think I'm just different ?

I have an Excel Workbook with Col. A approximately 1/8" wide. The formatting of this col is that the cells are set to have the typing fit into the cell, therefore it becomes so small that no one can read it. Just what I wanted. If the user needs to read what's in the cell, they can click on the cell and read it in the formula bar.

Col. B is approximately 2" wide

1st, the user enters the Path and File name, with extension, into cell A34(example).

2nd, the user types in a File Name that they will best understand into cell B34.

The Workbook is now saved.

When the user wants to open that file, they click on the Name . . . Col B34 - Easily recognized by the user.

They then click either the Button that say's "Open Excel File" -or- "Open Word File.

The macro automatically moves the selection over to column A, then the file is opened.

Now what I need

I want to use just 1 button and I will name it "OPEN"

The 2 below macros work excellant and I still need the functionality of each. What I want is that 1st it trys to see if it is an excel file and if so, opens the file and stops.

If the macro determines that it is not an Excel file, the macro then goes to the Word macro and determines if it really is a Word file and if so, opens the file and stops.

NOTE: I want to point out that I still need all the checking etc that the 2 macros currently do.

Here are the macros

OPEN EXCEL FILE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

View 10 Replies View Related

Combine 2 Macros Into One

Jun 16, 2007

I have 2 macros that work as I want them to. First one gets ride of formulas and formatting etc. and then deletes itself.

Sub Quote_Wrapup()
Range("A18:A1018").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Columns("A:E").Select
Range("A980").Activate
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B1021").Select
ActiveSheet.Shapes("Picture 14").Select
Application.CutCopyMode = False..................

I don't really understand how to combine them so that they will work as one.

View 3 Replies View Related

Dropdown Boxes With Months Shown That Change All Data

May 13, 2014

I have set up a sheet recording an each individual's turnover for my business i.e., hours worked, etc and have set up a data validation table for drop down options of Jan, Feb, Mar,etc....

Rather than creating more work for each month on the worksheet, how can I enable the drop down to contain the data specific to each month?

View 2 Replies View Related

Dependant Data Validation From Multiple Dropdown Boxes

May 3, 2007

I am trying to make a drop down list and based on what I select from the drop down needs to populate a different drop down list with information based on what I select.

For example: if I have Sheet1, Sheet2, Sheet3 and Sheet4.
Inside of Sheet4 (My Main Sheet) I have a Data Validation (Drop Down list) in Cell A5 and Cell B5

I would like to choose Sheet1 from Cell A5 and in that same sheet (Sheet4) in Cell B5 I want to have a drop down with a list of names that are located in Sheet1 in Column A:A.
Or If I would've picked Sheet2 in Cell A5 of (Sheet4), I would like to see a drop down with a list of names in Cell B5 (Sheet4) that are on Sheet2 in Column A:A . Is this possible?

So far I could achive it if information I want is located on the same Sheet. But I need it to work if info is located on different Sheets

View 9 Replies View Related

Combine 2 Working Macros Into One?

Aug 3, 2014

I now have 2 working macros but cant seem to combine them correctly. How do I get them both into one macro so they run together.

View 2 Replies View Related

Ambiguous Name. Can A VBA Combine 2 Macros

Nov 15, 2006

I've got two macros that work beautifully apart from one another ... but put the two in the same Excel workbook and they bump heads. I get the infamous "Ambiguous name detected: Worksheet_Change"

I know enough about VB to get myself into trouble. So, I'm asking for help from a talented person to show me how to combine the two ... or another work around to get through this.

Here are the two sets of code in my sheet that I think are causing the ambiguous name problem. How can I work around this error?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim varFind As Variant
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column 2 And Target.Column 9 Then Exit Sub
If IsEmpty(Target) Then Target.Interior.ColorIndex = 0

If Target.Column = 2 Then

Set varFind = Columns(16).Find(What:=Target.Value, LookIn:=xlFormulas, LookAt:=xlWhole)
If varFind Is Nothing Then
Target.Interior.ColorIndex = 0
Else
Target.Interior.ColorIndex = Cells(varFind.Row, 16).Interior.ColorIndex
End If
End If

View 9 Replies View Related

Creating Price Calculator Using Dropdown Boxes For Multiple BOMs

Apr 22, 2014

I am trying to create a price calculator for a particular product line which has multiple sizes and configurations. I would like to use drop down boxes so the user can select the size, type and attachments which will be narrowed down by the previous selections.

I would like the formula to be able to calculate the cost of the components based on the selections made. Based on some research I believe this can be achieved using data validation, indirect function and the vlookup function, however; I'm not quite sure how to go about this.

I have attached the document I have started for reference.

Chain Sling Price Calculator-4.xlsx‎

View 3 Replies View Related

Combine 5 Macros In A Sequence Into 1 Macro?

Nov 28, 2012

I have 5 macros to be run in sequence. I have copied them into the file attached with ----- line as separator between them.

How can I possibly combine them all into ONE MACRO?

View 5 Replies View Related

Excel 2007 :: Chart That Reads Results Of Multiple Dropdown Boxes?

May 25, 2012

Using Excel 2007

I have six colums (Date; Skill; ST Hrs; OT hrs: Area; Type). I copied and pasted below a small portion of info from the spreadsheet. I know when I copy and paste into a post the information under the headers don't line up exactly...it appears offset, so basically "Date" is of course the date you see..."Skill"'s columns has the first item as nb-mech b..."ST Hrs" first item will be 0.00..."OT Hrs" will be 1.50...."Area"'s first item is "Log FM NO"....and "Type"'s first item is MX07

And there are 17,000 rows of this info and forever growing...a lot of repeated items in each column such as you can see "blaster" has multiple entries on 4/1/2012.

What I am attempting to do which I have not firgured out yet (i have tried array formulas but they bog down the pc forver and couldn't figure out exactly how to make it give me the results I needed...and I also tried sumproducts but that didnt get me what I wanted....and it is being requested of me to NOT make a pivot table but a chart.

What I am trying to create is is the following:

1 - cells to plug in a date range for example cell A1 I plug 4/1/2012 and cell A2 plug 4/30/2012
2 - drop down boxes for columns Skill; Area: Type, which show only unique records in each column

Once I have that, I could then filter all 3 itmes and have only items show in the date ranges I picked and present ONLY the SUMS of columns ST Hrs and OT hrs.

Once the SUMS show up, I can then have cells off to the side that will give a percent break down of what percent of the total hours (for the chose criteria) are ST Hrs and what percent of the total are OT Hrs....and this percentage break down will show up in a Bar Chart, per day chosen in my date ranges....I'm thinking one simple stacked bar per day in the chart.

So say, based on the info below, I wanted to see the total ST Hrs and OT Hrs from 4-1-12 to 4-2-12 for a nb-blaster in LOG FM NO and type MX06.....my result would be 0.00 ST Hrs...23 OT Hrs.....and my bar chart would be one simple bar peaked out at 23 on day 4-1-12.....and within the bar it would be 0.00% ST Hrs and 100% OT Hrs and maybe the total hours for each showing also..don't need that but it may be useful.. ..and no bar for 4-2-12 (because the criteria picked had no hours for 4-2-12)

I have been messign witht is all week and just can't nail it.. I do remember a while ago I would have been able to load the spreadsheet into the post and people could see it in excel...is that option to do that no longer on this site?

DateSkillST HrsOT HrsAreaType
4/1/2012nb - mech b0.00 1.50 Log FM NOMX07
4/1/2012nb - scaffolding0.00 8.50 Bogs NOMX02
4/1/2012nb - coatings mech b0.00 3.00 Log FM NOMX07

[Code].....

View 5 Replies View Related

Combine Two Macros And Run Them On Double Clicking A Cell

Mar 20, 2009

I have two pieces of code. The first one puts a tick mark in the cell when you double click it. The second one hides column B of another sheet if the value in cell A1 of Sheet1 is "a". I want to combine these two codes so that when I double click cell A1 of sheet1 it puts a tick mark in the cell and hides column B of Sheet2 and clears the contents of range B2:B50 of Sheet2.

View 4 Replies View Related

Combine Two Macros In Same Worksheet Change Event

Oct 1, 2013

combine two Worksheet Change event macros into the one macro? The macros are listed below.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)On Error GoTo exitHandler
Dim rngDV As Range
Dim lRow As Long
Dim lCol As Long

[Code]...

exitHandler:

Application.EnableEvents = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("O:O")) Is Nothing Then
Application.EnableEvents = False

[Code]...

View 7 Replies View Related

Dropdown List In Spreadsheet Which Combine Info From Two Columns

Oct 24, 2012

I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.

For example:

A B
1 John 29
2 Sandy 40, etc

And the drop down list turns into

John 29
Sandy 40

Is this possible?

View 1 Replies View Related

Run Macros From Dropdown List

Sep 29, 2011

I have built a series of macros and want to be able to select from them in a drop down list. I can use a list or combo box to create the drop down list, but I am unsure how to write VBA to read the text and run the correlating macro (name of macro is identical to text shown in drop down list).

If this isn't possible, I would have to create a button for each of my 12 macros. How do I assign a macro to a button?

View 3 Replies View Related

Calling Macros Via Dropdown Box

Jun 20, 2007

I have a list of about 50 items sitting in a Data Validation dropdown list in an Excel cell, and I want my vba code to run every time the user makes a new selection. How can I do this?

View 2 Replies View Related

Combine Rows With Similar Info In Dropdown Menu Or Selection For User

Nov 29, 2012

I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.

Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.

test.xlsx

View 1 Replies View Related

How To Create Dropdown List Of Multiple Macros

Feb 18, 2013

I have 6 macros recorded and I need to create a drop down list of macros so that I know what kind of Macro I am using.

View 9 Replies View Related

List Boxes, Combo Boxes???

Jul 26, 2006

I am developing a spreadsheet with numerous information on our different suppliers offices in the country for each of our outlets. I am tryin to define a way to do the following:

If a colleague selects a company another list will appear with the region and when the region is selected a list of the offices will appear.

View 3 Replies View Related

Encourage Enabling Of Macros: Disable Macros When Opening Then The Worksheet Menu Bar And Other Command Bars Are Still Available

Aug 26, 2009

I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.

View 6 Replies View Related

Enable/Disable Macros When No Macros Are Present

Jul 28, 2008

I have a user that keeps a maintenance log in an Excel worksheet and sends an updated copy once a week to a board member. Two weeks ago, the board member started complaining that he was prompted to enable/disable macros on opening and became worried when my user stated that no macros were used in the book. He is now concerned that we have sent him a virus.

I know the file is clean because I've scanned it, and when I look at the file in VB, there are no modules or classes present just the Sheets 1-3 and the ThisWorkbook file. None of these objects have any code in them. My user does have some macros in PERSONAL.XLS but they are not used in the workbook in question.

No one else gets the prompt for enabling/disabling macros. Even if I set my security to prompt for any macros, I get no message. I'm convinced that there must be some setting in his Excel that is causing this individual to get this message. Is there anything else other than a macro that would cause this?

View 9 Replies View Related

Combo Boxes Based On Other Combo Boxes

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

How To Delete Another WorkBook Macros Using Macros

Jul 23, 2005

What is the commands or script for deleting a macro automatically using
another workbook macro.

View 9 Replies View Related







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