gasraqueen.blogg.se

1. Youtube date drop down in excel how to#
2. Youtube date drop down in excel update#
3. Youtube date drop down in excel code#

I still don't like that, I need to force Excel to do a calculate after the save. OK, so now at least, when the worksheet changes, it's doing a calculate, and that's getting updated.

Youtube date drop down in excel update#

Let's see if it updates when I update the worksheet. I'll do a debug compile just to make sure that Excel sees that is now volatile, re-enter this function.Īlright and now, so we'll do a save, still not updating.

Now, let's see what happens if I press the F9 key, still not updating.Īlright, so that means that we have to come back here and mark this function as volatile, application.Volatile like that. Or we can do Ctrl+1, and let's see, I think there's one that shows both date and time like that, although we have to add the seconds.Īlright so, create some sort of a format, so we can see that it's working.Īlright, so there's our Podcast1725, I will save!

OK, so there's the right answer in the wrong format, we need to format this as a date and time, or short date, or a time. This should be really simple, just come back here, =LastSaved(), Enter! That's good, because I didn't misspell anything. So I just put a 1 in there so that way that line is valid for a moment, and we'll Ctrl+C to copy that, replace the one, Ctrl+V, and yep, it capitalizes everything. So LastSaved is equal to, and I want to copy this from down here, but if I click down here, it's going to give me a compile error. No arguments that were going to pass it, and a user-defined function has to return the variable with the same name as the function. I'm sure I have the debug.Print activeworkbook.FullName, that gives us the path and file name.Īnd I need that path and file name for the function called filedatetime, which would give us a date and time that this was saved.Īlright, so we're going to insert a Module into this workbook, will call it function, what we call it now, maybe LastSaved. So we're going to switch over to VBA with Alt+F11, Ctrl+G to show the Immediate window, I'm just going to do a couple of tests down here. Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.Īnd today's question sent by Wes, Wes is looking for a user-defined function to give us the last time that this workbook was saved. Learn Excel from MrExcel podcast, episode 1725 - Function for the Last Saved Time! MrExcel podcast is sponsored by "Easy-XL"! Visit us: for all of your Microsoft Excel Needs! "The Learn Excel from MrExcel Podcast Series" But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year.

Youtube date drop down in excel code#

VBA and Macros: Microsoft Excel 2010 - The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve.Includes crucial information on making Excel 2010 VBA code work with older versions.

Youtube date drop down in excel how to#

Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful.įor more information on Excel 2010 VBA and Macros, check out. Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Today, in Episode #1725, Bill shows us how to add a small Macro to our Workbook that will show the Date and Time the Workbook was saved. Wes wants to know the last time a particular Workbook was saved.