• 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

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  2. A

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

    Due to the word limit, I'll post this in two parts;-
  3. A

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  4. A

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  5. A

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  6. A

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  7. A

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

    Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...
  8. A

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

    Luke M, what a star! Thank you very much! Once again your code worked like a charm! As you've probably guessed, I am relatively new to VB (completely self-taught) and although I know a little, some things are beyond me. To explain why I am using hyperlinks for my checkbox's - this is...
  9. 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...
  10. A

    Select a range via hyperlink then print selection automatically

    Thanks Asa, it's good to know there are a few different ways to accomplish the task, I have not tried your method yet, it does seem a little tidier and I will try this at some stage, but since I have a functioning system for printing/editing now, I have moved on to another problem which I am now...
  11. A

    Select a range via hyperlink then print selection automatically

    Scratch that! It was my own stupidity! I had not updated my hyperlink references to highlight/reference the correct cell(s) so therefore everytime I was clicking on any "Edit" hyperlink, it was taking me to the exact same cell everytime and then {F2} was being fired (incorrectly on my part)...
  12. A

    Select a range via hyperlink then print selection automatically

    Thanks Asa/Narayan, Hopefully to make things a little clearer, I think what I want is multiple "IF" statements, but I'm not sure of the syntax I should be using, let me explain;- Something along the lines of;- If Target.Value = "Print" Then (print code goes here) Else Target.Value...
  13. A

    Select a range via hyperlink then print selection automatically

    Hello again Related to the post above, I have a hyperlink which selects Q1 Analysis, Q2 Analysis etc. and I wanted some code which would fire when each was clicked to allow the user to edit the respective Analysis. I can get each hyperlink to selet the appropriate cell, that is no problem...
  14. A

    Select a range via hyperlink then print selection automatically

    Many thanks Luke M and to Prasad for the original response, To be honest, I wouldn't have ever thought of doing that at all instead of merging cells (well ok, maybe after HOURS of scratching my head and getting nowhere!). It just goes to show what a bit of lateral thinking does -...
  15. A

    Select a range via hyperlink then print selection automatically

    Thanks Luke, that also works like a charm! Thank you for your time. On the subject of the merged cell issue - I don't have to use a merged cell, but the trouble with not using a merged cell is that because of the way my data is set up and the position I want the "Print" hyperlink in, the...
  16. A

    Select a range via hyperlink then print selection automatically

    Addendum to post above, I have just noticed that if my "Print" cell (the cell with the hyperlink to range "C2:Q6") is in a merged cell, the above macro doesn't fire. The correct range of cells is still highlighted as you would expect, but the SelectionChange event does not appear to be firing...
  17. A

    Select a range via hyperlink then print selection automatically

    Hi Prasad Many, many, many, many thanks!!!!! Option 1 works like a charm! I bow to your superior knowledge - I have been scratching my head over this for AAAAAGGGGGGGES!!!! Having said that.... since you mention the "Selection.PrintOut Copies:1" command which is great, is there a way of...
  18. 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...
View older results
Back
Top