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

    Data Validation with VBA

    Perfect! Thank you so much!
  2. C

    Data Validation with VBA

    Well, I have a followup question. When I protected the document, I ran into some final issues. Doc is at https://www.dropbox.com/s/a75e3yw0dlaw5ni/Copy%20of%20GB%20Timesheet%20Template%20040313.xls and has the password of 1* Once I protect the document and enter data in C, I get an error...
  3. C

    Data Validation with VBA

    You are most magical! Thank you so much for you patience and assistance! It is working perfectly!
  4. C

    Data Validation with VBA

    It seems to be behaving the same as before - MsgBox always comes up. I would still prefer to have the cell shading appear in G, H and I and data entry into C without any MsgBoxes.
  5. C

    Data Validation with VBA

    Of course! Just happy for the help!
  6. C

    Data Validation with VBA

    It's so wonderful! I was hoping to have the shading just as a visual reminder versus an actual MsgBox. Would you be able modify such that there's no MsgBox? I tried taking out both message boxes and that worked ok but then I discovered that the shading from all 3 cells, G, H, I, also...
  7. C

    Data Validation with VBA

    What I want is that when a work order number (or any text) is entered into column C (work order column) it will automatically highlight the cells in the same row in columns G, H and I (a light shade, like R 221 G 217 B196). I don't want to make G, H and I required, but I want to highlight them...
  8. C

    Data Validation with VBA

    So sorry about that! Try this... https://www.dropbox.com/s/32l4ocmdx3ri0vk/Copy%20of%20GB%20Timesheet%20Template%20030113_1.xls
  9. C

    Data Validation with VBA

    Try this sample file https://www.dropbox.com/s/32l4ocmdx3ri0vk/Copy%20of%20GB%20Timesheet%20Template%20030113_1.xls
  10. C

    Data Validation with VBA

    Sorry, I think I initially posted this as a reply on another post. I have a spreadsheet where, when data is entered into column B, I want data entry to be required in columns G, H and I. G, H and I happen to be data validation dropdown lists. I would also like columns G, H and I to show a...
  11. C

    data validation

    I would like to do something that I think is similar to the above. I have a spreadsheet where, when data is entered into column B, I want data entry to be required in columns G, H and I. G, H and I happen to be data validation dropdown lists. I would also like columns G, H and I to show a fill...
Back
Top