Use Excel Macro to Show a Message When Necessary
Loading...
Loading...
2,359
Loading...
There is no Interactive Transcript.
Uploader Comments (contextures)
see all
All Comments (5)
-
Great tutorials. Yeah, the music is distracting. Don't need it. You have a very nice voice and the video is exceptional clear. Thanks for the video tutorials. I am the star in work because of - you!
Loading...
5:47
make your own fake message boxby hellzar246,444 views- 3:25
Basics of Customizing ArcMap with VBA programmingby GISTutorials4,021 views
- 7:43
VBA : VBA Code For Creating a Message Box In Excel With Yes/ No Options (Hindi)by excelmadeasy1,603 views
- 1:35
Excel VBA Userformby Dandandidi4you62,235 views
- 6:28
How to Merge Multiple Excel Workbooks to a Master Budgetby DannyRocksExcels41,052 views
- 4:17
Excel 2010 - A Simple Macro - MacroMountain.comby MacroMountain1,709 views
- 7:22
Visual Basic Tutorial - #1 - Make a Message Boxby x86tutorials716 views
- 4:28
IF ERROR - A Cool New Excel Functionby skierpmh2,931 views
- 4:22
Excel Vba Msgboxby needfullthings1,168 views
- 3:16
VB6: Yes/No message boxby danagol19856,329 views
- 1:47
Adding Row Automatically After Each Cell Macro Usage.mp4by macrobooknet583 views
- 6:02
Excel VBA - MsgBox Functionby ExcelScreencasts329 views
- 5:34
Excel VBA tutorial 2 Using the Range Property to Select Cellsby Malfunction97,778 views
- 5:15
Using Excel Macros to Process Real Time Data Acquired by the Excel Server from LowCostBoards.comby crdejohn2,620 views
- 2:58
Hide Specific Excel Sheets With a Macro Shortcutby contextures941 views
- 4:04
MrExcel's Learn Excel #828 - 2007 Macrosby bjele12319,540 views
- 4:03
Use Excel VBA Macro to Show a Warning Messageby contextures1,999 views
- 1:39
Learn How to : Create an auto running Macro in Microsoft Excel 2007by OfficeHelpOnTap3,841 views
- 1:22
Mensagem de boas vindas - Excelby edilsonrafael527 views
- 1:50
Excel Form Data Entry In Columns A - Dby excelvisualbasics7,294 views
Hello! I was wondering, to you have any idea how to error trap a date input? I will enter dates on a specific column (complete dates such as 11/05/2010) and error trap if the input has the year of 2011 and not 2010. I know data validation does that, but only if the cell is manually inputted. If the input in the cell is pasted, it does not do that anymore.
pokwang021 10 months ago
@pokwang021 You could adjust the code in this example, so instead of checking for an empty cell, it checks the year in the cell's date.
Or, use a formula in another cell, to check if the cell values are valid dates. If the dates are not valid, conditional formatting could fill key cells with black fill colour and black font, and show an error message.
contextures 9 months ago
Great video thanks... Can you either lose the music or lower it? Distracting. :)
krn14242 1 year ago
@krn14242 Thanks for your comment, and I'm glad you liked the video.
Unfortunately, I can't change the music now, but I've uploaded a new caption file. You could turn off the sound, and just read the captions. Hope that helps!
contextures 1 year ago