Open PoP Up With Answer
Oct 14, 2009i 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
ADVERTISEMENT
VBA To Automatically Answer Pop Up On Open.
Jan 11, 2010I 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.
Opening My Spreadsheet Which Will Only Open If The Correct Answer/ Password Is Typed
Apr 22, 2009upon opening my spreadsheet which will only open if the correct answer/ password is typed.
I’d need to store the questions, passwords/ answers somewhere for VB to look up I guess??
Capital of England – London
Capital of France – Paris
Capital of Italy – Rome
Etc etc
And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.
Same Formula, Why Can't Get The Same Answer??
Jun 4, 2009in 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 RelatedIF Argument Need With Yes/no Answer
Nov 11, 2009I 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 RelatedGet An Answer Based On A Value?
Jan 1, 2010I 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 RelatedAutoSum: The Answer Should Be 8
Jul 3, 2009I 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)))
Text Box For Other Answer
May 24, 2008I 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
Return Answer Dependant On /
Apr 5, 2009in 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
Answer Only If Greater Than A Number
Apr 12, 2013How 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?
Add Dropdown That Pops Up Only When Certain Answer Is Given?
Nov 20, 2013I 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 View RelatedVlookup Or ? (Get Answer In B Column)
Oct 4, 2009I 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....
Determine MsgBox Answer
Dec 15, 2006The 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
Automatically Answer YES To Alert
Jan 6, 2007My 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 RelatedIF Formula Returning Wrong Answer
May 1, 2014I 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 RelatedChanging Sum Of Two Cells To Equal -4 If Answer Is Zero
Dec 8, 2013I 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.
Sum And Divide Three Different Sets Of Numbers To Get One Answer
Dec 16, 2013I 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)
Selecting Answer From Multiple Cell
Dec 27, 2013So 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 RelatedReturn Answer Based On Cell Value
Aug 29, 2009im looking to return an answer in cell c28. in b28 it will say "best goalkeeper"
in c28 i need a formula to look in range d2:d6 then return the highest answer and correspond that to whats in b2: b6. so we could say
(b2)shilton(d2) 33
(b3)corrigan (d3) 55
(b4)parkes (d4) 66
(b5)schmeichel (d5) 100
(b6)cudicini (d6) 14
in c28 it will return the answer schmeichel because he is the highest
and in d28 it would return the points he has.
Compare Four Columns, Give Yes Or & No Answer
Sep 17, 2009I have the attached worksheet with clients' names in four columns (A-D). The first names and last names must remain separate. I need one additional column that shows whether a full name (first and last) in C and D also appears in A and B.
Then one more column that shows how many times the name in C and D shows up, but only if it is also in A and B.
How Can I Skip Or Automatically Answer Of Message?
Nov 23, 2009I have a workbook that contains a macro that when executed creates a copy (duplicate) of one its sheets and places it in itself (the same workbook). The macro then prints the newly created sheet. After printing, the macro then erases the newly created sheet so that it is no longer a part of the workbook. My problem is that I get the Excel message "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete". I would like add to my macro so that 1) the message is skipped or 2) the macro answers the message box (with Delete) so that no user input is required. I would like it if the user did not have to respond to this message.
View 2 Replies View RelatedParenthesis - Formula Give An Answer Of 178
Oct 27, 2005The following formula shoud give an answer of 178. I think I am placing the
parenthesis in the wrong position.
The answer I get is 308669
=(((F22*71449)*0.4)+16147/C22)
Cell-F22 number is 1826
71449 is a constant number
0.4 is a constant number
16147 is a constant number
Cell-C22 is 10.8
Can IF Function Result In Its Answer In A Different Cell?
Jan 15, 2010Can this Formula work? Where if c2<e5 then its value is a number. The formula below is what i tried but it didnt work
=IF((C2<E5);"c5=value=f5")
Formula Correct But Not Showing Answer
Mar 11, 2013I am using this formula for long now
=SUMPRODUCT(('[Diesel Statement.xlsx]Nov 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Nov 12'!$G$2:$G$251)
every month i just add a new sheet and change the month name in the formula to that eg
I changed it to
=SUMPRODUCT(('[Diesel Statement.xlsx]Dec 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Dec 12'!$G$2:$G$251)
but now it is not calculating the answer is coming as #value!.
Then I tried to add up by
=VLOOKUP($H$1,'[Diesel Statement.xlsx]Dec 12'!$C$2:$G$215,5,TRUE)
but it does not add all the entries only one entry is shown.
I want the total of the column G. looking up for values in C = H1 value
Get Picture To Pop Up When Certain Answer Is Selected In Cell
Mar 20, 2014How I can get a picture to pop up when a certain answer is selected in a certain cell, or when a certain answer is keyed in to a cell. Another portion to this question is that we know how to get a message to pop up in a dialog box when a certain piece of information is typed in to a box, but we don't know how to get graphics into those dialog boxes.
View 3 Replies View RelatedIf Statement Providing Incorrect Answer?
May 20, 2014In cell K8 is the value (General) 800. In C8 is the value (Also general format) 768.
=IF(C8
Is A Dynamic Named Range The Answer
Jun 1, 2007I have a sheet containing three drop down boxes which gives me a count of data in a table matching the criteria. (Between 2 dates and equals a depot name).
I am trying to create a chart to only show this data, but I don't want to do it using a pivot table as the end user has no understanding of them and just wants to fill in drop down boxes.
I am beginning to think that using a Dynamic Named Range might be the answer. I believe I am able to achieve what I want with this process but I am not entirely sure how to do it.
“Reply To All” With Standard Answer In Outlook
Sep 23, 2007I’m currently writing a code, which will enable me to run a code, which will reply to a selected email with standard text in the cc, subject, body, and so on.
The code that I managed to write creates a new email message, instead I want the code to select "reply to all" to the email that I’ve selected, and then fill in the cc, subject, body, and so on.
Sub test()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.Display
msg.CC = "test@hotmail.com"
msg.Subject = "testing!"
msg.Body = "hello all" & vbNewLine & vbNewLine & "We agree to your call..."
End Sub
Conditional Format (vba Loop Is The Answer)
Oct 21, 2009i have 3 columns and hundreds of rows.... i first applied conditional format to the first row (A1, B1, C1) only. no problems so far as A1 has value '0' which is minimum and B1 is the highest value '200' and C1 is variable value between 200' and 0'. Im using icon sets in this one.... now i want the below rows to have the same conditional format.... how do i do that because when i select them all rows and columns and try to apply conditioanl formatting the outcome is not the same as i got previously in the first row...it somehow combines all the values rather working only on the individual row. i hope u get wat im tryin to say....
i come across a solution in my mind to give a loop in vba to do the conditional formatting each row seperately untill empty cell of column no. 4.... but doing this will obviously eat lot of memory in excel cause of each row will have a seperate conditional format.....
Remove All Bracket & Data.answer
Oct 26, 2009i need to remove this all bracket & data.answer should like this.
ex-
column "A"
AS-18881(C-8567)
SP-25768(G-856)
AS-25687(C-687)
ex-
column "A"
AS-18881
SP-25768
AS-25687