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

    Shorten some text strings from a list

    Hi, I have a list of about 6000 records which are a mixture of text and numbers. the string is either: Numbers, text, numbers, text or: Text, numbers, text or: Text, numbers. I need to write a formula (or UDF) to remove the last (right hand side) text from all the records which have it. Any...
  2. P0lar

    How to put a numeral value in parenthesis below '+' sign in same cell

    Hi Sonia, I had a go and got the following to work - In a cell, e.g. A1 type '+ [ALT + Enter] (N) Then use = SUBSTITUTE(A1,IF(N44>0,"(N)","N"),N44) Then paste the format from A1 to the cell you want to display the value - I have no idea why this step works as both cells are formatted...
  3. P0lar

    Hyperlink mouseover formula help!

    Thanks Jordan, Think I follow your logic, I'll give it a try as it may help to streamline my workbook (with it's astonishing number of hidden things). Unfortunately I can't upload files from the network I'm on but I'll be putting in some additional bits over the next few weeks as workloads...
  4. P0lar

    Hyperlink mouseover formula help!

    Quick update - linking a macro to a shape rather than to the selection change event worked but for some reason the code was only able to change a single cell, further cell changes on subsequent lines of the macro were ignored but I adjusted the sheet accordingly and it's now doing what I was...
  5. P0lar

    Hyperlink mouseover formula help!

    Thanks, I had the same problem using the follow hyperlink approach but I think I may have a new route, if I put a rectangle over my table and set the fill to white, 100% transparent, then the mouseover hyperlink seems to get picked up "through" the transparent shape but I can only click on...
  6. P0lar

    Third Dimension Plotting, possible without bubble charts?

    If you set the background of your bubble chart to no colour then you can possibly fake what you're after by placing the two graphs on top of one another, but you'd need to make sure your axis lined up properly (okay if the scales don't change, needs some thought if they do).
  7. P0lar

    Hyperlink mouseover formula help!

    ... or so I thought! the changes I made have done something odd to the macro and some of the lines in the code don't work anymore (others are fine). My mouseover formula is: If Not Application.Intersect(Application.Caller, Range("i50:o55")) Is Nothing Then Range("d67") =...
  8. P0lar

    Hyperlink mouseover formula help!

    Thanks for spotting that! Went back over the hyperlinks, I'd picked up the slight differences from another section of my sheet but not realised I'd changed them from the original. Some slight tweaks to the selection change code later and it's working.
  9. P0lar

    Hyperlink mouseover formula help!

    Hi, I've used the hyperlink formula trick from the (very nice) dashboards examples elsewhere on the site to run a user defined function when I put the mouse pointer over a cell =IFERROR(HYPERLINK(MyMouseOverEvent(),""),"Text"). I also have a macro which runs when I select the cell with the...
Back
Top