1. I

    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.
  2. L

    # of Mondays between 2 dates

    Hi I was watching a video on how to calculate # of mondays between 2 dates. He used this formula = 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...
  3. M

    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...
  4. P

    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...
  5. N

    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...
  6. H


    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...
  7. R

    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...
  8. A

    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...
  9. S

    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...
  10. D

    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...
  11. O

    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...
  12. T

    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...
  13. D

    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...
  14. T

    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...
  15. F

    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...
  16. R

    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...
  17. T

    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...
  18. S

    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...
  19. T

    General question about this forum

    I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...
  20. JenniferMurphy

    How to post a workbook with code?

    I have written a Sub that I would like to post with some questions. I also have a workbook that calls that Sub to demonstrate how it works and illustrate the questions. Since attachments are not allowed, I would upload it to Dropbox and post the link. But what's the best way to do that? I...

Some videos you may like

This Week's Hot Topics