response

Hi there, I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you! Sub ssFav() Dim...

Hi Forum, I a building a spreadsheet for work, to help manage and track our mailbox, were I have a list of multiple employee types (column c), Date received (COLUMN D), date replied (Column e), people who responded back to them (Column G), response status (h), what the question pertains to...

Hi, would it be possible to have a warning box pop up to prevent saving the PDF over an existing file? Also, can we have the box show the existing filename and be able to change the name and then save it? Thanks Sub DETAIL_PDF() Dim response As String Dim PrintAreaString As String...

Hello, I hope everyone is well. Long time, no post :) I receive non-normalized data from our field staff who are in teams of 2. For our final analysis, we choose only the team lead (indicated in its own field/column as TL). However, on rare occasion, they leave their response blank and we need...

Hi everyone. Im having some challenges using online Forms for Excel. Ive made the form, but the responses from the form are all in "General" format, but no matter what I do I cannot use vlookup to pull data from it for newly received responses. I can copy and paste format only on to a...

The below code used to export to PDF saves fast on one computer and very slow on another similar computer. On the slow computer I use Foxit and not Adobe. Does that matter? Do I have to have Foxit as an add-on in excel? If I save the file manually using the menu and save as it seems to work...

Hello, I would like to know how to develop an automated email response based on user response. This is what I would like to develop: Using Outlook 2007 a template is created with a mail list group and two buttons that allow the recipient to either Approve or Deny the specific event. Once the...

Hi Can anyone advise for a macro that will check cell A2 for a value of "True" If cell A2 does contain "True" then return a messagebox "Are you sure this is the correct selection?" vbyesno if vbyes is pressed then continue with code or if no is selected exit sub This must be run from a command...

I am looking at a response from VBA Geek here https://www.mrexcel.com/forum/excel-questions/795401-macro-extract-10-highest-values-1-column-onto-new-sheet.html I am looking for something identical - BUT adding in a criteria lookup on a column i.e. Top10 values IF column C = "X" Original...

For some reason, the code below isn't moving on to the Else statement when the value of R26 isn't > 0. Can someone help me understand where I went wrong in my code please? Sub Assign_MD1() Application.ScreenUpdating = False Dim mTP, mSumm, mMD1 As Worksheet Dim Response As VbMsgBoxResult Set...

G'day, I have a url for API call: eg: http://<api ip="" address="">User=<<IPADDRESS>>:123456&Type=XYZ currently i need to manually change values for those variable to see the status of those users. i get the response in XML. i have 1000 users and Type of users are PrIV or PER. for each of...

Hi All, Please help me in extracting hours from two responses given date and time, keep in mind to calculate if response received within business hours. For Ex: [SIZE=2][FONT=arial] * Here, please consider business time starts and ends at 08:00 AM - 05:00 AM * Saturday and Sunday should be...

Hi everyone please help me. I have difficulty in my excel formula. I have my start date 4/2/2018 (a1) and completed date 4/11/2018 (b1) to calculate within a month which until 4/30, value must be 1 otherwise 0 (c1) Thank you in advance for you response.

I need a help with the following: A1 to h1 will have a default value of either 1 or blank ( this indicates the number of attempts the student makes for the exam ) Now in Cell J1 I want the response "module repeated" if any of the values from A1 to H1 is changed from 1 to 2 or 3 or 4 etc...

The following is not closing after five seconds of no action by the user. Can anyone suggest a reason. Sub inactivityShellPopUp() Const ShowDurationSecs As Integer = 5 response = 7 response = CreateObject("WScript.Shell").PopUp( _ "This program will close in " &...

A couple of years ago I constructed this code with the help of Mrexcel; Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim WasProtected As Boolean Dim response As VbMsgBoxResult Dim adjust As Integer On Error GoTo myhandler...

Good morning, In one of my excel sheets I have raw data from a likert scale with 20 questions. On another sheet I wish to tally how many of each response I received across all questions. I need help with the formula for this tallying function.

Please help an old novice out. The last time I was heavy into Excel was before the year had a "2" in the front (1990's). :eeek: I have a Excel questionnaire I've made that has 5 pages to it. The first page has two drop down cells for responses. if either of the two are yes, the other pages need...

Hello, I am designing an excel file which will provide me the company website URL taking the Company name as Input. For this I have found out a free API which does this exact Name->Domain mapping. The API goes like this: https://autocomplete.clearbit.com/v1/companies/suggest?query=[C_NAME]...

Hi, I have the code Sub Iteration_Status()Dim response As Variant 'input box that can accept both text and numbers response = Application.InputBox("Enter Iteration Status Number", "Numbers Only", , , , , , 1 + 2) If response = "False" Then 'code distinguishes between "False" on clicking the...