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

    Message box to come up when a cell is left blank

    Answer from Vletm - means nothing to me, I didn't understand your answer. Answer from David Evans - No, I haven't tried data validation as I can't see how it can work. I would much prefer a message window via VBE to work this issue. If you can help with this, I would appreciate it...
  2. M

    Message box to come up when a cell is left blank

    I would like the VBA code for the following: Cell A1 has a popup calendar Cell A2 is for filling in number If cell A1 is left blank (without the popup date inserted) and cell A2 has a value entered, then I would like a popup message saying 'Must fill in the date" I have a range of cells...
  3. M

    command button coding for clearing content of specific cells

    A very late thank you for helping me on this question a few weeks ago.
  4. M

    command button coding for clearing content of specific cells

    I would like to set up a command button in VBA that, when activated, clears the contents of specified cells in a worksheet (with a caution 'are you sure?') Could you let me know the coding for this, please? Thanks
  5. M

    Screen size

    On exiting a worksheet, I would like to make sure the screen size stays the same as it was previously set and not the size I have changed it to while viewing this particular worksheet.
  6. M

    Creating a print command button and VBA code to print selected cells

    Thank you so much for your time on this, it works perfectly.
  7. M

    Creating a print command button and VBA code to print selected cells

    I have another problem I am trying to resolve. In a workbook with six worksheets, I am trying to get it to always open in sheet1 regardless of which sheet I am in when I exit. I have highlighted the 'workbook' in VBE and on the right side boxes put in 'workbook' in the left box with 'open' in...
  8. M

    Creating a code to open a worksheet at a set cell

    I would like to be able to press on the bottom tabs in a workbook so each worksheet opens at a predetermined cell each time and doesn't go back to where it was left on a previous viewing. Also, when opening a workbook, I would like it to open at the first worksheet at a set point and then by...
  9. M

    Creating a print command button and VBA code to print selected cells

    I haven't used this website for some time and, believe it or not, I can't seem to find where to post a question! Please could you help on this. This must be the dummest question you have had to date!
  10. M

    Creating a print command button and VBA code to print selected cells

    I only joined this forum today, (the only one I have ever joined), so I didn't expect such a quick response! So thank you very much for your help. I will give it a try and report back.
  11. M

    Creating a print command button and VBA code to print selected cells

    I am using excel 2010 and I am a raw beginner in the use of VBA. I would like to have a command button on a worksheet that, when clicked, automatically prints a selected area of the worksheet e.g. (a2 to g24). I have eight sections in this worksheet requiring a command button so wish to assign a...
Back
Top