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

    Warehouse visualization

    Vletm, Thank you for your response, unfortunately its not exactly what I was looking for, but i like what you were able to do, it does provide an alternate way to look at it. Attached is the "result" I was hoping to get to, but i would like each level represented, not as an entire row like I...
  2. G

    Warehouse visualization

    did my response answer your question or do did I miss it? Is what I am asking possible?
  3. G

    Warehouse visualization

    Each level is the same height but stacked on each other to represent a racking system, and the color would be to represent the values based on a scale, maybe 3 tiered conditional formatting. the first numbers represent the bin row numbers, the Alpha character represent the height levels, A being...
  4. G

    Warehouse visualization

    I want it in a 3d graph so I can rotate it to see the variations, this is an example of what I want it to look like, but my description above is more complete layout
  5. G

    Warehouse visualization

    I am trying to create a visualization of a warehouse showing areas of high volume that I want to color code, Red for high volume through blue for low volume, but I want to represent this in a 3d format so I can see a each location in its respective rack in its respective row with about 10 bin...
  6. G

    Engineering charts - too much data, i can't graph, HELP!

    On this data set, all degrees have at least 1 value
  7. G

    Engineering charts - too much data, i can't graph, HELP!

    I am trying to scatter plot measurements of angles, I have 360 degrees listed on the columns and I have 243,000 measurements, each measurement is placed depending on the degree it falls, however, because of this amount of data, I can't graph more tan 255 columns or rows. does anyone know how I...
  8. G

    worksheet change event only working once

    I figured it out. so simple. when I protect my sheets the change event that it was linked to was locked under the protection, so excel couldn't select the cell until it was unlocked. so thanks for your support in trying to help me.
  9. G

    worksheet change event only working once

    I can do that on Monday. I hope you can help. it's a really big deal that its not working, it worked before but now its not. so I really appreciate it.
  10. G

    follow hyperlink event

    I have a hyperlink in my worksheet. the hyperlink goes to a website, when it goes to the website I can search for an address. I have the address 5 columns to the left of this hyperlink, I want to be able to allow the person to select the hyperlink but have vba copy the address, so when they go...
  11. G

    worksheet change event only working once

    sorry, I can't do that. I initially created to code on the first sheet. it was a change event in cell F2. I then copied the exact code and pasted on a different sheet to perform the exact same thing, but on this sheet it won't run but once and then the change event doesn't seem to work. that...
  12. G

    worksheet change event only working once

    I am using a scanner to scan barcodes on a list (items I am trying to find). I created a worksheet function using case select when case = $F$2, so when the user scans the barcode when the cell F1 is selected, it will execute. every barcode I see I scan and gotes through each one, one after the...
  13. G

    create an interactive map in excel.

    I want to be able to put in a list of addresses, they show up as an interactive icon in a map of the USA. then I want to be able to see the icon change based on some KPIs and then click on the icon to get more information. Is this possible with VBA and perhaps google maps. I need the map to be...
  14. G

    vba how to go to webpage and select the export to excel button

    Is there a way to do this for other similar websites? just want data tables to do analysis on.
  15. G

    vba how to go to webpage and select the export to excel button

    What was that anyway. It got exactly what I wanted but no idea what it is.
  16. G

    vba how to go to webpage and select the export to excel button

    I am trying to write some vba to go to this page and click the export to excel icon. does anyone know how to do that. here is the web page...
  17. G

    Code only working in debug mode.

    I commented them out and still, exact problem persists.
  18. G

    Code only working in debug mode.

    Yes, i know the routine; however, i am absolutely not allow to upload or download anything from the internet with out IT security analyzing and approving. so that is not an option for me.
  19. G

    Code only working in debug mode.

    I added the wait code between the two and getting the same error in same place; no debug code or error code, just stops the vba and the VBA application is not opened either, just literally nothing.
  20. G

    Code only working in debug mode.

    a) There is no delay b)118 kb is the size, the code does require the file being opened and pasted to to be saved, currently loops 9 times. c) inserted DoEvents in both locations, one at a time and same thing happens. Stops in same location and ends the code, not debugg error, just stops.
Back
Top