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...
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...
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
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.
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...
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...
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!
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.
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...