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

    Insert value into Adjacent Cell, when Hyperlink is Clicked

    Hi folks I currently have a column (column D) with a list of names and the names are clickable with the =HYPERLINK() formula;- =IF($B7="","",IFERROR(HYPERLINK(A7,VLOOKUP(B7,Database!$A:$AH,12,0)&" "&VLOOKUP($B7,Database!$A:$AH,11,0)),"")) The cells all function and take me to the...
  2. A

    Tabbed Workbook Browsing within Excel - a la Firefox - using VBA?

    Hi folks Does anyone know if it is possible to create a tabbed browsing interface for workbooks within Excel VBA? There are some add-ins available online which are (as far as I can tell) all 'pay-for' items but I was just wondering if this feature would be achievable in VBA? Most of the...
  3. A

    Unlocking/locking ScrollArea when following Hyperlinks

    Hi all I have a "Dashboard" worksheet (menu) with hyperlinks to all schools within the area, each hyperlink goes to the appropriate section of an "IncidentsDashboard" tab which contains incidents of Bullying/Racism for a particular school - for example, clicking on the first school name will...
  4. A

    Code Streamlining and fixing

    Hi everyone Apologies in advance for the lengthy post, my code is quite long. Could someone please take a look at the code below for me and firstly, see if they can fix a couple of things that aren't quite working the way i want them to, and secondly, see if the code can be streamlined in...
  5. A

    Print to PDF using VBA and merge resulting PDFs into single document

    Hello there! I have managed to create a way of mail-merging in Excel using an earlier version of my code below, basically pulling in large amounts of data incrementally to the same template "form" and then printing each in turn to a PDF. However, what I wanted to do was try and combine/merge...
  6. A

    Generate dynamic report using a template and cycle through data on the fly

    Hi everyone What I have is an "Index" Worksheet and a SearchBox that the user can use to search my database for certain keywords (Performance Indicator data). There is a cell underneath the SearchBox which contains a ValidationBox that is filtered/restricted to the values the user has...
  7. A

    Saving an Excel Workbook is SLOOOW - even with all VBA disabled

    Hi I have an Excel Workbook which is working perfectly, however upon saving, it takes an AAAAGE to save - seriously, I could grow a full-on ZZ-Top style beard in the time it takes to save. My file is only around 500kb in size, and I have temporarily disabled all VBA to try and troubleshoot...
  8. A

    Prevent scrolling except when following hyperlink

    Hi guys & gals Related to my other posts (in that it's the same spreadsheet I'm working on);- http://chandoo.org/forums/topic/change-in-cell-tickcheck-box-value-in-multiple-ranges-using-selectionchange and...
  9. A

    Set Data Validation Box to top value within search criteria

    Hi there I have a SearchBox (actually just a cell with a named range of "SearchBox") in my spreadsheet which allows the user to type a search term (obviously) which then restricts the results within my DataValidation drop-down cell to those items that meet the search criteria. Now what I want...
  10. A

    Change in-cell tick/check-box value in multiple ranges using SelectionChange

    Hi folks I have a group of cells in $D$23:$I$23 & $D$25:$I$25 that I want to change to Tick/Cross values (a checkbox without using Form Controls or ActiveX Controls) and I have managed to do this with VBA, however the problem comes when trying to copy this to multiplpe ranges within the same...
  11. A

    Select a range via hyperlink then print selection automatically

    Hi guys I want to be able to click a hyperlink in cell "I1" and then this will activate range "C2:Q26". Once the hyperlink is clicked and the relevant range is selected, I then want to print the selection automatically. The print range has to be dynamic. Basically, I have a range of data...
Back
Top