• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Trying to extract Currency Symbol from a cell

    I'm not sure what you're assignment requires, but you're able to do it without VBA which might make life a little easier. In another cell I would use the Find() formula to return the location of your search string. then I would put that location into a Mid() function like you've done above...
  2. J

    Music in excel

    "sounds" - ha!
  3. J

    Using Excel to download data from Access databse

    I've done this a few times for my work and I think the best way is detailed in this article: http://support.microsoft.com/kb/257819. Basically, you'll reference an ADO object and use it to connect with the Access file. From there, you'll supply the ADO connection with some SQL which will...
  4. J

    Debugging custom vba function

    Hey, so I downloaded the file your linked to and I don't see any problems on my side. Could you be more specific on the errors that are popping up?
  5. J

    Wingdings 2 Ticks and crosses

    Well, I would still suggest the side-by-side solution. However, instead of using a control, you can use Data Validation (under the Data tab, in Data Tools). You could create a "Yes/No" drop down like the ones described here: http://www.contextures.com/xldataval01.html. Then, in the cells...
  6. J

    creating a template from an existing table

    When you copy any cells, all formulas should be retained as is (so long as you do a regular paste and not paste special). If you simply copy the desired region and paste into a new spreadsheet (or tab) your formulas should remain intact, you'll just need to adjust your input data in the new...
View older results
Back
Top