Add Dropdown That Pops Up Only When Certain Answer Is Given?
Nov 20, 2013
I would like to add a drop down that pops up only when a certain answer is given in a previous cell. For instance, if the user picks "Single Door" in cell E2, then in cell E6, I would like a box to pop up that says "HL/HR?" so that in cell E7, they have a drop down & can select either HL or HR. But, if they pick anything other than "Single Door" in cell E2, I don't want a box to pop up in cell E6 to prompt them to do anything else.
View 2 Replies
ADVERTISEMENT
Sep 26, 2008
I am a newbie to Excel. I really appreciate if someone could help me here and this is very urgent as I have a project going on.
I have a cell say B3, which is a dropdown list I created using Data Validation. It only lists down Yes or No.
What I need is when you click on Yes in B3, i need columns C to I to unhide. If answer is No, column C to I should be hidden. By default, the columns will be hidden.
Can you please help? I tried many times but not successful. Appreciate if someone will be able to walk me through details. If you want to see the sample spreadsheet, I can sent it to you by email. I tried Data> Outline group but they are not happy with this.
View 9 Replies
View Related
Feb 8, 2012
Measurement in cell A2 need to be with range and C2 also needs to be in range. I need the result E2 to be an ABS value of A2-C2 and if either are blank to show as a blank. Issue is a zero pops in when one cell has data.
In the pass/fail cell is a formula to see if its in range and comes back with pass fail.
Thk 1: 0.095" - 0.105"Pass / FailThk 2: 0.095" - 0.105"Pass / FailParallelism: ≤ 0.0005" 0
View 2 Replies
View Related
Jul 25, 2007
Does anyone know how to use a form checkbox that adds the true/false values to a cell to activate a msgbox when the cell value changes?
I've tried assigning a macro to the checkbox and uses "If not intersect" in VBA but it doesn't work.
What I'm trying to do is assign a value to cell A1 depending on whether the checkbox assigned to cell A2 is clicked and the value of cell A2 becomes true or false.
Thank you to anyone who can help me out. Auto Merged Post;One more thing to be clearer about my question ... I'm trying to do change the value of cell A1 on click of the checkbox assigned to cell A2, meaning when the value of cell A2 changes.
View 4 Replies
View Related
Feb 3, 2009
I was wondering if there is a way to get rid of this? There are about 300 emails that are going to be sent out and this comes up every time.
Or if there is a way to only do it once no matter how many emails get sent.
Here is part of the code..
View 12 Replies
View Related
Apr 28, 2009
During the course of one of my macros running I want it to press the Delete button that pops up? I used to know but can't seem to trip across it. I have attached a screen shot of the Delete button I want to be pressed.
View 4 Replies
View Related
Oct 18, 2009
When I run my Excel 2003 macro, the attached message pops up. Is there a way please to modify my macro so that when this Excel message pops up, it automatically selects OK?
View 3 Replies
View Related
Apr 22, 2008
i've gotta demo an Excel app in a few days and this never really bothered me, but someone recently pointed out that it can get distracting for the Control Toolbox to pop in and out randomly. the form is being built for use by other staff, and i suppose it would also be distracting for them if the toolbox arbitrarily appeared here and there. is there a way to turn it off?
View 2 Replies
View Related
Oct 14, 2009
What I am after is a user form that pops up when I enter ‘Y’ in cells in Column ‘L’ which displays the contents of the cells in that row e.g. if I enter Y in cell L2 a user form would pop up displaying the contents of cells A2 to M2
The A2 to M2 column headers are:-
First Name
Surname
Code
Address line 1
Address line 2
Address line 3
Address line 4
Address line 5
Post code
Telephone
Comments
The user form can be Read only i.e. I do not need to edit the cells (although that would be good) as it will be used as a source document to input into another application, however, a ‘Print’ button to print the form would be beneficial. The only other button required would be a ‘Close Form’ option.
View 4 Replies
View Related
Sep 11, 2013
What is this error message that is popping up when I try to insert a blank row of cells?
"To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.
If you do not have data in cells that can be shifted off the worksheet, you can reset which cells Excel considers nonblank. To do this, press CTRL + End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save."
This excel document we have has LARGE amounts of data
View 3 Replies
View Related
Jul 30, 2014
I have an Excel file in Shared Mode...
Now, when it starts, I have a popup form asking for password for access for it. The problem is that for one person - AND ONLY THAT PERSON - the VBA Editor window opens and she has to press the "Play" button for it to hide and be able to enter the password to access the application.
The editor is not showing on any other computer. All computers are running Excel 2010.
View 2 Replies
View Related
Mar 27, 2007
the following code should determine whether the searched value can be found in more than just one row and than enlist certain values from each of those rows in ComboBox4 using a loop. Then I have a second macro which would assign appropriate values from a Sheet to other text boxes whenever one changes the value of the ComboBox4:
Private Sub ComboBox2_Change()
Dim vFind
Dim Firstaddress
Dim rFound As Range
Dim wsName As String
Dim SrchRng As Range
wsName = Me.ComboBox1.Value
With Worksheets(wsName)
vFind = UserForm2.ComboBox2.Value
Set rFound = .Range("B1")
Set SrchRng = .Range("B:B")
Option Explicit
End With...............................
While trying to run the first macro an Error pops up saying that a variable within the loop is not set. I've got no idea how to fix it
View 9 Replies
View Related
Aug 13, 2007
When I delete a worksheet, via code, a warning pops up telling the user that a data is subject to deletion.
View 9 Replies
View Related
Apr 10, 2009
I have created a form that pops up using a macro when the form is opened. It is a simple form that uses optionbuttons in a group to select Intl or Dom.
Problems:
1) How do you get the form to close once a button is selected?
2) The user can close the form without selecting a button (the X at the top).
3) How do you get the data selected onto the excel spreadsheet?
View 9 Replies
View Related
Jun 4, 2009
in the "Order for EMS" and "Order for FEDEX" there have 1 product exist, now the customer need to type the country in the "F35", and the Price of weight will look back to the sheet "EMS Weight" and "FEDEX Weight" but for example, if i type Japan in both sheet, the EMS that one is correct 1kg to Japan is $168 but in FEDEX that one is not correct 1kg to Japan is $169 but now show $342, the formula in "G36" should be correct, what's wrong of my formula????
View 3 Replies
View Related
Nov 11, 2009
I have a sheet that has 2 fields that i need a yes/no answer from. Basically if b = "P1" then a should be less than or equal to 4 to reply good otherwise it should reply no. but if b isnt "P1" but instead is P2 P3 or P4 then it should => 10, 30, 40 respectively.
View 8 Replies
View Related
Jan 1, 2010
I want to tell Excel that, if a cell value is between 1 and 100, to enter one result in another cell. If the value is between 101 and 250, enter another result in that same cell. If the value is between 251 and 500 enter another result in that same cell and so on about another 12 times.
View 5 Replies
View Related
Oct 14, 2009
i just wanted to know if we can open a pop up which will give us answers. i have attached a example work sheet of what i require
View 3 Replies
View Related
Jul 3, 2009
I have a formula that is in ColF Row4, and it is copied down to ColF Row 13. But trouble is that when I autosum this column I get 6, but the answer should be 8.
The data in Rows A-E are extracted from an external data source. I've attached the spreadsheet. =IF((AND(A4=7,D4="")),1,(IF((OR(A4=7,D4>=2)),D4,0)))
View 4 Replies
View Related
May 24, 2008
I have to following code. I have an issue now where I have to Pop a textbox from based on the answer to one of my questions.
If cboProjOffset = "Other" Then
userSalOther.Show
Problem is I actually want the text box to populate on the same line of the range answer in column m. At present it doesnt seem to be doing this. Can anyone help?
Public gintEditMode As Boolean
Public gintTotalEntries As Integer
Public gintLineNumber As Integer
Private Sub cboProjOffset_Change()
If cboProjOffset = "Other" Then
userSalOther.Show
End If
End Sub
View 9 Replies
View Related
Apr 5, 2009
in cell d1 i have
hk/q46559
in cell i1 i need to return whatever is before the "/"
in this case hk
and in cell i2 i need to return the number after the q
in this case 46559
View 3 Replies
View Related
Jan 11, 2010
I have a few 2007 workbooks that are set up to track and compare individual budgets over time. The majority of the cells are referencing workbooks that have yet to be created.
On opening these workbooks the users are confronted with an informational window informing them that "This workbook contains one or more links that cannot be updated", to which they are instructed to choose "Continue". Is there code I can add to these workbooks that would automatically choose "Continue" once a user enables the security warning for Automatic updates of links? I believe this would be the same as an On Open event.
View 7 Replies
View Related
Apr 12, 2013
How do you put an answer in a cell after subtracting 2 numbers and if greater than a number put that answer in. This isnt right just an example
=IF(a1-a2 is greater than 10 then put that answer in the cell if not just leave it blank?
View 5 Replies
View Related
Oct 4, 2009
I have data in A column.
I want to Get anser in B Column.
Sheet1 ABC1S.NoCountryCode2E8481234567CroatiaE8483E8351234568SloveniaE835472123456900Ireland725JM123457000LuxembourgJM Excel tables to the web >> Excel Jeanie HTML 4
Answer Based on C Column....
View 9 Replies
View Related
Dec 15, 2006
The macro I am working on will ask the user if they wish to transfer data to one of two Forms, held in two separate worksheets. The worksheet names are Record Form Games 3583 & Record Form PE 3581. The msgbox will ask "Is the data being transferred to Record Form 3583?" If Yes the sheet "Record Form Games 3583" will be set as the sheet as the one to transfer data to. If no "Record Form PE 3581" will be the destination sheet. This is what I have so far:
Sub Do_Admin()
Dim Record_Form As Worksheet
Msg = "Is the data being transferred to Record Form 3583?"
ans = MsgBox(Msg, vbYesNo)
If ans = vbYes Then Set Record_Form =
Sheets(Sheet"Record Form Games 3583")
End Sub
View 2 Replies
View Related
Jan 6, 2007
My macro cuts and pastes a section of one sheet over the top of each remaining sheet in the workbook. It pauses before each paste and presents a message box (relating to copying over a named range) requiring the user to manually click on "Yes" in response to the question before continuing on. How can I modify my macro so that it finishes without requiring the user to click on "yes" for each sheet. In other words, how do I get the macro to automatically answer "Yes" to the message box ??
View 2 Replies
View Related
May 1, 2014
I am trying to determine if I can write a formula that will read text in one cell, such as insurance and if true enter the amount from another cell and if false then 0. I have tried a IF statement by add the text to name manager. However, the answer is 0 rather than the amount in the selected cell. I might need to use a different formula or function.
View 10 Replies
View Related
Dec 8, 2013
I wish to be able to add adjacent cells as follows, assuming I have a number in a1. (in B1) =a1-4.
If the answer is zero I would like to change it to -4 and then continue the process for more cells to read 16 ; 12 ; 8 ; 4 ; -4 ; -8 ; -16 etc.
View 6 Replies
View Related
Dec 16, 2013
I have three different sets of numbers on a r12m that I have to add and divide by different numbers and not quite sure I have the formula right as when I do it manually on a calculator it comes out different.
The formula I have put together is
=sum(O4:z4)/10)+(sum(o5:z5)/200)+(sum(06:z6)/1000)
This is the three rows of data
221121
2333443201142
402448314034292331351663
Using the formula above the result is 0.81 but if I do it manually on a calculator it is 1.6 (by doing each line individually and adding results)
View 6 Replies
View Related
Dec 27, 2013
So I am creating a board game in excel. I currently have a draw card feature to draw random cards. I also have section above where you can fill in the answer to the question and another 2 sections that flip to correct or incorrect. Those formulas work as =IF(AND(Sheet1!J6="When resubmitting the claim to another insurance should you be voiding an adjustment to the S code if one is posted?",Sheet1!I2="Yes"),"That is Correct!"," "). I have another for if Sheet1!i2="no" then it flips to that is incorrect. I want an OR formula that will be like if multiple cells have any text in them it will display them but only one cell at a time. So essentially a way for multiple questions to be able to be drawn and you can answer those questions and be told if they are correct or not.
View 14 Replies
View Related
