# questions

1. ### Extract Question from String of varying Text

Trying to extract a question from a string of free form text in Excel. Expected Result: How many licks to the center of a tootsie roll pop? Side question, what if there are multiple? Example: This is a test of what I am looking for. How many licks to the center of a tootsie roll pop...
2. ### Practice a quiz but I couldn't!

Hello everybody, For the quiz questions, I tried using the circular method, but got a numeric, period or comma error? So I tried using the solver to find the same solution I got, but when I entered it in the answer box, he always said incorrectly. Any help would be highly appreciated and...
3. ### How many posts in this forum are required for submitting a link?

Hi I am new here. I want to follow the rules of this forum. i want to know "number of post" for sharing a link in this forum. Thanks.
4. ### # of Mondays between 2 dates

Hi I was watching a video on how to calculate # of mondays between 2 dates. He used this formula = networkdays.int(start date, end date, "0111111") I understand 0111111 to show only Mondays, 1011111 to show only Tuesdays etc but my questions, why he used that as 3rd argument when the 3rd...
5. ### Dropdown selection, further dropdowns afterwards?

I'm trying to figure out the best approach for this task; - user selects yes or no from a dropdown (or a check box would be nicer visually) - if user selects no, nothing happens - if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not...
6. ### ThisWorkbook Question

Hi All, I'm trying to use a different code structure for the NAMED tab of "Tab_ONE" with the following: ThisWorkbook.Sheets("Tab_ONE").Range("B11:X180")) Is there anyway to restructure this to use the for example, Worksheet(2) in lieu of "Tab_ONE"?? Please let me know, if you should have...
7. ### Pass Target.Address to Function to see if it falls within a range

I apologize for my noobness with VBA upfront. I'm attempting to teach myself VBA while adding some code to a project at work. All help is greatly appreciated. I'm creating a form that will be filled out by others that may not be as familiar with the material as I am. I'm attempting to code...
8. ### Charts

I need to add two horizontal lines at 60% and 90% to a bar graph. I also need to change the text color for one of the items in the Y axis. They are survey responses and the text of the word is in the Y axis. I need to differentiate one of them that is reverse coded by font color or italics. I...
9. ### Risk Profiler

Hi, I doing investment risk profiler in excel. Basically, what I want to achieve is that each letter on the questions corresponds to a number and based on the user's choice it will add up on the analysis box. The score then will be evaluated as aggressive, low risk, or mid risk. My question is...
10. ### Excel based questionnaire

Dear Colleagues, I need to establish excel based on questionnaire which is basically start with 5-6 questions, once submitted by user, it should generate main questionnaire based on inputs ( for example if the question of "are you student?" was answered as "yes", there will be additional...
11. ### Auto increment numbering based on a cell value

Good morning all I have a worksheet "Quiz" which displays random questions taken from a question bank. These questions are annotated into column B4 onwards, based on the number of questions requested. I am trying to number these questions using VBA, but cannot find any code which seems to work...
12. ### Formula not returning correct outcome

Hi, I need help with a formula that is not returning the correct outcome. I work for an awarding body and to pass one of our qualifications you need to achieve a minimum of 60% and at least score a 1 in all 12 questions answered. If you score 60% but score a zero in one question, you are still...
13. ### perform calc based on if other cells are populated

I am wondering if anyone has any suggestions to assist me with my problem. Below is a sample of what my data looks like. A B C D E F G H I J 62 Shop 456.20 NO YES NA NA NA Overtime 63 Check 8756.00 YES NA...
14. ### VBA Macro to Hide/Unhide Rows Based on Criteria

I know very little VBA, but from what I've read it is the only way to automatically hide rows in a worksheet. I am attempting to do the following: The cell Q9 in the current worksheet is determined by data from 'ProjectDataSheet'!J43 and assigns the text according to that cell remaining blank...
15. ### ActiveSheet.Range and ActiveSheet.AutoFilter.Range Questions

I have a few questions: 1) I am trying to delete all the rows in Col 4 with #, the code I have is this: ActiveSheet.Range("\$A\$1:\$AJ\$11576").AutoFilter Field:=4, Criteria1:="#" ActiveSheet.AutoFilter.Range.Offset(1, 0).Rows.SpecialCells(xlCellTypeVisible).Delete (xlShiftUp) 2) How do I...
16. ### Syntax Help

I'm using the following formula to automatically determine a form specification based on whether the user selects custom questions or custom questions in conjunction with a specific client but it keeps returning an error message that only tells me there is a problem with the formula. It's...
17. ### Looking to use buttons/macros to create a question box (text box) that can cycle through 5 questions using forward and back arrows.

Would this be possible? I’m new to macros and have basically no VBA knowledge but wanted to make a text box or similar change the text inside by clicking the arrow right or left to cycle between around 5 questions. I hope this makes sense, I teach basic functional skills ICT and this would be a...
18. ### OptionButton: Boolean vs Long, and why -4146?

Hi Folks, I've been doing some reading up on the Multiple UserForm Controls with One Event Handler concept, and a few questions have arisen... :confused: Some (most?) of the articles I've read talk about using Long variables vs. Boolean to hold the value of OptionButtons & CheckBoxes. The...
19. ### Creating a Survey in Excel??

Hello, I am looking to create a Survey inside excel. I have 45 different locations and I would like to know what locations the customer has been to. I have created a check box list of all the locations. I would like the customer to select all the locations they have been to and then on then on...
20. ### All possible outcomes to 12 questions in a spreadsheet

Hi - first time posting here. Hope you can help. I'll try and be as clear and as concise as possible. I have 12 questions (which form part of an assessment). Each question carries a simple "Yes" or "No" answer. This gives me 4096 different possible outcomes (2^12), for a completed assessment...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back