Last seen: Jun 11, 2026
Hi Dave, I had not seen this before but I can reproduce it. Also, if you leave A1 selected, click in the formula bar, then hit Enter, the data is ...
Hi Nina, Yes the workbook I provided has working event code in it. You just needed to put what code you want into that event handler/sub. But, ...
Hi Nina, The workbook I attached to my last reply contained the event code for you to use. You just need to copy the email code that you were alre...
Hi Maya, I'm a bit confused by your reply. The reference to PERSONAL.XLSB is added to the workbook that you want to use the function in. This f...
Hi Nina, Using Worksheet_SelectionChange the VBA is executed every time you move to a different cell. By using Worksheet_Change you can limit the ...
Hi Maya, This is a bit of a pain and another one of those things in Excel that you scratch your head at and wonder why they did it this way. Tha...
Hi Gene, Can you attach the document so I can have a look? Thx Phil
Hi Marilyn, Outlook stores all its macros in a single file called VbaProject.otm. This file is already part of your roaming profile and is located...
No worries, glad it worked for you. Yes the trailing slash must be included in the saveFolder, otherwise there's no directory separator Cheers ...
Hi Marilyn, You need some VBA to do this, and use a rule to trigger it. First open your VBA editor from within Outlook by pressing ALT+F11. On ...
Hi Sarfraz, Have you looked at this The sheet is attached as a PDF, as you have to save the sheet as something, maybe a PDF or a workbook. Phil
Hi rathanak, why don't you use the built in auto save features, rather than write VBA to do this? Regards Phil
Hi rathanak, In addition to SunnyKow and ConnexionLosts's answers you can read up on time calculations Excel Time Calculation Tricks Calculat...
Hi Ron, You could use a date picker in your form so the date is always in a known format. No typing required for the user either. Regards Ph...
Sorry about that Gilbert, there was a typo in the link to the video. That's now fixed and the video is working. Regards, Phil