Guidelines

Guidelines

  1. Posting & Forum Use Tips

    1. Read the MrExcel Message Board FAQ
    2. Before you even post a question, have you searched for an existing answer for it? Read Searching in the Board
    3. Make sure you are posting to the correct forum.
    4. Include a meaningful title that is specific to your question. Good: "Excel VBA Type Mismatch Error", Not so good: "Help needed!"
    5. Everyone here is a volunteer, so make it as easy as you can for people to help you.
      1. State your question clearly, including your entire need at the start.
      2. Add some representative sample data - actual data is much better than an image (see also "Posting Aids" below).
      3. Tell us what formula/code you have currently, and why your results are not what you want.
      4. Include which version of Excel and Operating System you are using.
      5. If you are looking for help with an error received, what is the actual error message and where exactly does it occur?
      6. Before posting, read your question back to yourself to check it will make sense to somebody unfamiliar with your worksheet.
      7. Be patient. The more you 'push' for help, the less likely you are to receive it
      8. If you are truly in urgent need, check the Consulting Services page.
    6. If the answer you receive is inadequate for some reason, post a reply stating why the answer does not work and/or with more information (if needed) in the same thread.
    7. If your question has not received any replies, do not start a new thread. Click the Forums drop down menu item on the toolbar (top left) and select "Your Threads" to find your threads. Alternatively, use Advanced Search for a more detailed search. You can "bump" posts back up to the top by posting a reply in the thread. Also refer to Rule #12 about re-bumping your threads.
    8. If one or more posts were particularly helpful, click the Like button on that post. Getting Likes increases a person's reputation.
    9. If you wish to make a complaint about another member, please use a Report button (at the bottom left of any post or Private Message) to send a message to the moderators.
  2. Posting Aids

    1. You cannot attach or upload actual files as samples.
    2. However, you can upload images and you can use XL2BB tool to generate compatible BBCode for MrExcel Message Board from the selected Excel worksheet range.
    3. If posting VBA code, please use Code Tags with vba option - like this [code=vba]Paste code here[/code] - or use the Code button on the editor toolbar (), then copy and paste your code into the text box in the code dialog window. Make sure VBA Code is selected as Language.
    4. There is a Test Here forum on this board where you can test these posting aids before using them in your actual questions.

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top