How to detect Scroll position of a webpage using jQuery's .scrollTop()

The .scrollTop() function in jQuery allows you to get the current vertical position of the scroll bar for the first element in the set of matched elements or set the vertical position of the scroll bar for every matched element.<br /> <br /> You can extract the scroll position of a certain page or element using the <a href="http://api.jquery.com/scrollTop/" rel="nofollow" target="_blank">jQuery's .scrollTop() method</a>.<br /> <br /> <br /> <pre class="brush: java">$(window).scroll(function (event) { var scroll = $(window).scrollTop(); // Do something });</pre> <br /> You can also determined the percentage and alert the user that he has scrolled certain amount within the document. <br /> <pre class="brush: java">$(document).scroll(function(e){ // get the scroll value and the document height var scrollVal = $(window).scrollTop(); var docHeight = $(document).height(); // calculate the percentage when the user scrolls down the page var percentage = (scrollVal / docHeight) * 100; if(percentage > 50) { // call the function called alertUser alertUser(percentage); } function alertUser(scrollPercentage) { // alerts the user that he has scrolled certain amount within the document alert("You have scrolled down at " + scrollPercentage + " of this page"); } });</pre>

jQUERY How to detect Scroll position of a webpage using jQuery's .scrollTop()

The .scrollTop() function in jQuery allows you to get the current vertical position of the scroll bar for the first element in the set of matched elements or set the vertical position of the scroll bar for every matched element. You can extract the s…

Read more »

VB.Net Print PDF Document

<b>Portable Document Format</b> (<b>PDF</b>) is a file format used to present documents in a manner independent of application software, hardware, and operating systems. Each PDF file encapsulates a complete description of a fixed-layout flat document, including the text, fonts, graphics, and other information needed to display it.<br /> <br /> In some applications, web or desktop there are several options where you can convert or Print a <b>PDF</b> version of a form or document you're reading. So, the question is how is it done and is it possible to create your own PDF document from scratch? We'll you're still lucky as I am.<br /> <br /> In this tutorial you'll be able to learn on how can <b>VB.Net Print PDF Documents</b>.<br /> <br /> <h2> Requirements</h2> 1.) CodePlex.com provides a freely downloadable version of the <a href="http://pdfsharp.codeplex.com/downloads/get/96263" rel="nofollow" target="_blank">PDFSharp-MigraDocFoundation-Assemblies</a>.<br /> 2.) Extract the downloaded .zip file to your project folder. The file name if not updated is PDFsharp-MigraDocFoundation-Assemblies-1_31.zip.<br /> <br /> <br /> <h2> Creating the Project</h2> 1.) Start you Microsoft Visual Basic 2010 Express.<br /> 2.) Create a new Windows Application Project.<br /> 3.) In the <b>Solution Explorer</b> Panel, <b>Right Click</b> on your <i>Project's Name</i>. Then choose <b>Add Reference</b>.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmmMnzOnPFvb8SwsKVl5B1O9P3sH10ePE5K59gysKPX0OYfETOGCbs9QarI6yWw17cRFzIheaxL2aCMQQR6RLWFL12UpuF8ij4IiW6QGPpB-K-_p7Zr6kalewBf9PZ_RrAGsyOcY-mM_VJ/s1600/Vb.Net+Print+PDF+Document+-+Solution+Explorer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmmMnzOnPFvb8SwsKVl5B1O9P3sH10ePE5K59gysKPX0OYfETOGCbs9QarI6yWw17cRFzIheaxL2aCMQQR6RLWFL12UpuF8ij4IiW6QGPpB-K-_p7Zr6kalewBf9PZ_RrAGsyOcY-mM_VJ/s1600/Vb.Net+Print+PDF+Document+-+Solution+Explorer.png" width="320" /></a></div> <br /> 4.) In the <b>Add Reference</b> dialog window, Click the <b>Browse</b> Tab. Locate the folder where you extracted the <b>PDFSharp Assemblies</b>.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdpVRT32eMomr-l23_UZlxo-MNZITxL0ZEtTxv3yA57FnN0www_rrOwJQpu5RmZiZLTi3i6MhM-FC_cisOEczIkQz6tG3EM3ZeWJygrGk8a6DQj7UOFMKIeuO1rLxL_II1m6PDfYcuTBGq/s1600/VB.Net+Print+PDF+Document+-+Add+Reference.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="269" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdpVRT32eMomr-l23_UZlxo-MNZITxL0ZEtTxv3yA57FnN0www_rrOwJQpu5RmZiZLTi3i6MhM-FC_cisOEczIkQz6tG3EM3ZeWJygrGk8a6DQj7UOFMKIeuO1rLxL_II1m6PDfYcuTBGq/s1600/VB.Net+Print+PDF+Document+-+Add+Reference.png" width="320" /></a></div> 5.)<b>Select All</b> of the .dll files then Click <b>OK</b>.<br /> <br /> Once the done, <b>Click</b> the small arrow to expand the references in <b>Solution Explorer</b> Panel and it will most likely look as the image below.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPY-3RgBdlt2WSy4HAcGGrSYoZB8ypEHG_xepOkTUHlbAAD3UUgOhkgvcYsy9YGyQXxhB8FSd3l3rjiYUxTRO8h19IZVZ1XgQc1o7mLW0aYZo1YPT5vsilGL4XK34cXVConGZtZMI8B50H/s1600/Vb.Net+Print+PDF+Document+-+References+Added.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPY-3RgBdlt2WSy4HAcGGrSYoZB8ypEHG_xepOkTUHlbAAD3UUgOhkgvcYsy9YGyQXxhB8FSd3l3rjiYUxTRO8h19IZVZ1XgQc1o7mLW0aYZo1YPT5vsilGL4XK34cXVConGZtZMI8B50H/s1600/Vb.Net+Print+PDF+Document+-+References+Added.png" width="276" /></a></div> <br /> <br /> <h2> Design Mode</h2> Add a <b>Button</b> Control on the form.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4EWSY0U5nQqsnGium6y_2hjnPNoLO0L_u1a_-EIPPVuXssMGcM7EsK044VMGPY-0lQk6yGCfZQ2m2FpRpGPAE544j3vKE_5T9Y8wH9zqwfzLgykG9037x6dlESbbtc-7DR5pZ9RLjjvsU/s1600/Vb.Net+Print+PDF+Document+-+Add+Button.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4EWSY0U5nQqsnGium6y_2hjnPNoLO0L_u1a_-EIPPVuXssMGcM7EsK044VMGPY-0lQk6yGCfZQ2m2FpRpGPAE544j3vKE_5T9Y8wH9zqwfzLgykG9037x6dlESbbtc-7DR5pZ9RLjjvsU/s1600/Vb.Net+Print+PDF+Document+-+Add+Button.png" /></a></div> <h2> Coding your Project</h2> <b>Double Click</b> the button control then <b>Copy</b> and <b>paste</b> the following codes in your <b>Code Editor</b>. <br /> <pre class="brush: vb">Imports PdfSharp Imports PdfSharp.Drawing Imports PdfSharp.Pdf Public Class Form1 Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim pdf As PdfDocument = New PdfDocument pdf.Info.Title = "My First PDF Document" Dim pdfPage As PdfPage = pdf.AddPage Dim graph As XGraphics = XGraphics.FromPdfPage(pdfPage) Dim font As XFont = New XFont("Verdana", 20, XFontStyle.Bold) graph.DrawString("You've just created your first PDF document.", font, XBrushes.Black, _ New XRect(0, 0, pdfPage.Width.Point, pdfPage.Height.Point), XStringFormats.Center) Dim pdfFileName as String = "C:\MyFirstPdfDocument.pdf" pdf.Save(pdfFileName) Process.Start(pdfFileName) End Sub End Class</pre> <br /> <h2> Explaining each Line of Codes</h2> Import the required namespaces. <br /> <pre class="brush: vb"> Imports PdfSharp Imports PdfSharp.Drawing Imports PdfSharp.Pdf</pre> Create a PDF document object. <br /> <pre class="brush: vb"> Dim pdf As PdfDocument = New PdfDocument</pre> Create a new page. <br /> <pre class="brush: vb"> Dim pdfPage As PdfPage = pdf.AddPage</pre> Set the title of the PDF document. <br /> <pre class="brush: vb"> pdf.Info.Title = "My First PDF Document"</pre> Create a Graphics Object. <br /> <pre class="brush: vb"> Dim graph As XGraphics = XGraphics.FromPdfPage(pdfPage)</pre> Create and Set a font style from XFont. <br /> <pre class="brush: vb"> Dim font As XFont = New XFont("Tahoma", 24, XFontStyle.Bold)</pre> Adding content to PDF document and Add it to Center. <br /> <pre class="brush: vb"> graph.DrawString("Congratulations! You've just created your first PDF document.", font, XBrushes.Black, _ New XRect(0, 0, pdfPage.Width.Point, pdfPage.Height.Point), XStringFormats.Center)</pre> Save the PDF Document at your most preferred location. <br /> <pre class="brush: vb"> Dim pdfFileName as String = "C:\MyFirstPdfDocument.pdf" pdf.Save(pdfFileName)</pre> Launch the newly create PDF document. <br /> <pre class="brush: vb"> Process.Start(pdfFileName)</pre> <br /> <h2> PDF Output</h2> When you click the button, it will create the pdf page and open the pdf file. As you can see below. <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBr6m_Ksqs0_X4V4g3Q8rN2Vttn61IEb6Fs-AcT5U7ZRg66VKmghsXbCj5IgBM3w7C3enfbxZaeJOaS7fXtwdmkwZVxjzM0z_xaLrCXU8_9FxRQyKHvFMELMTkrZD9nYrvSeg1dkKi6BH8/s1600/Vb.Net+Print+PDF+Document+-+My+First+PDF+Document.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBr6m_Ksqs0_X4V4g3Q8rN2Vttn61IEb6Fs-AcT5U7ZRg66VKmghsXbCj5IgBM3w7C3enfbxZaeJOaS7fXtwdmkwZVxjzM0z_xaLrCXU8_9FxRQyKHvFMELMTkrZD9nYrvSeg1dkKi6BH8/s320/Vb.Net+Print+PDF+Document+-+My+First+PDF+Document.png" /></a></div> <br /> Now, you've just learned how to create your first pdf document. Download the <a href="https://www.dropbox.com/s/kec5b338bid6p5z/Print%20a%20PDF%20Document.rar?dl=0" rel="nofollow" target="_blank">VB.Net Print PDF Project</a>.

dotNet VB.NET vb.net print pdf VB.Net Print PDF Document

Portable Document Format (PDF) is a file format used to present documents in a manner independent of application software, hardware, and operating systems. Each PDF file encapsulates a complete description of a fixed-layout flat document, including t…

Read more »

Formatting Date and Time VB.NET

The Date literal must be enclosed within number signs (<b>#date#</b>) and specify the date value in the format <b>M/d/yyyy</b> like <b>#09/06/2014#</b>. Else, the way how your code is interpreted may vary depending on the locale in which your application is deployed.<br /> <br /> With this requirement the meaning of your code should never change whether if it has a different date and time format settings. For example, you hard-coded a <b>Date</b> literal of #9/6/2014# which means September 6, 2014. That will compile 9/6/2014 as you want mm/dd/yyyy. However, if you deploy application in several locales using dd/mm/yyyy date format, your hard-coded literal would compile to June 9, 2014. For other locales using yyyy/mm/dd, the literal would be invalid causing compilation error.<br /> <br /> To convert a Date literal to the format of your locale or to a custom format, use the Format function of String class, specifying either a predefined or user-defined date format.<br /> <br /> <h2> Predefined Date/Time Formats</h2> The following table identifies the predefined date and time format names. These may be used by name as the style argument for the Format function: <br /> <table cellpadding="0" cellspacing="0"> <tbody> <tr> <th>Format Name </th> <th>Description </th> </tr> <tr> <td>General Date, or G </td> <td>Displays a date and/or time. For example, <span class="code">3/12/2008 11:07:31 AM. Date display is determined by your application's current culture value.</span> </td> </tr> <tr> <td>Long Date, Medium Date, or D </td> <td>Displays a date according to your current culture's long date format. For example, <span class="code">Wednesday, March 12, 2008.</span> </td> </tr> <tr> <td>Short Date, or d </td> <td>Displays a date using your current culture's short date format. For example, <span class="code">3/12/2008. The d character displays the day in a user-defined date format.</span> </td> </tr> <tr> <td>Long Time, Medium Time, or T </td> <td>Displays a time using your current culture's long time format; typically includes hours, minutes, seconds. For example, <span class="code">11:07:31 AM.</span> </td> </tr> <tr> <td>Short Time or t </td> <td>Displays a time using your current culture's short time format. For example, <span class="code">11:07 AM. The t character displays <span class="code">AM or <span class="code">PM values for locales that use a 12-hour clock in a user-defined time format.</span></span></span> </td> </tr> <tr> <td>f </td> <td>Displays the long date and short time according to your current culture's format. For example, <span class="code">Wednesday, March 12, 2008 11:07 AM.</span> </td> </tr> <tr> <td>F </td> <td>Displays the long date and long time according to your current culture's format. For example, <span class="code">Wednesday, March 12, 2008 11:07:31 AM.</span> </td> </tr> <tr> <td>g </td> <td>Displays the short date and short time according to your current culture's format. For example, <span class="code">3/12/2008 11:07 AM.</span> </td> </tr> <tr> <td>M, <span class="input">m</span> </td> <td>Displays the month and the day of a date. For example, <span class="code">March 12. The M character displays the month in a user-defined date format. The <span class="input">m character displays the minutes in a user-defined time format.</span></span> </td> </tr> <tr> <td>R, <span class="input">r</span> </td> <td>Formats the date according to the <a href="http://msdn.microsoft.com/en-us/library/system.globalization.datetimeformatinfo.rfc1123pattern.aspx"> RFC1123Pattern</a> property. For example, <span class="code">Wed, 12 Mar 2008 11:07:31 GMT. The formatted date does not adjust the value of the date and time. You must adjust the Date/Time value to GMT before calling the <span class="input">Format function.</span></span> </td> </tr> <tr> <td>s </td> <td>Formats the date and time as a sortable index. For example, <span class="code">2008-03-12T11:07:31. The s character displays the seconds in a user-defined time format.</span> </td> </tr> <tr> <td>u </td> <td>Formats the date and time as a GMT sortable index. For example, <span class="code">2008-03-12 11:07:31Z.</span> </td> </tr> <tr> <td>U </td> <td>Formats the date and time with the long date and long time as GMT. For example, <span class="code">Wednesday, March 12, 2008 6:07:31 PM.</span> </td> </tr> <tr> <td>Y, <span class="input">y</span> </td> <td>Formats the date as the year and month. For example, <span class="code">March, 2008. The Y and y characters display the year in a user-defined date format.</span> </td> </tr> </tbody> </table> <br /> <h2> Pre-Defined Format Example</h2> The following example demonstrates how this can be achived. <br /> <pre class="brush: vb"> Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim SampleDateTime As Date = #9/6/2014 1:14:23 PM# Debug.Print("Formatting Date and Time Examples:") Debug.Print("Using Format 'D:' " & SampleDateTime.ToString("D")) Debug.Print("Using Format 'd:' " & SampleDateTime.ToString("d")) Debug.Print("Using Format 'T:' " & SampleDateTime.ToString("T")) Debug.Print("Using Format 't:' " & SampleDateTime.ToString("t")) Debug.Print("Using Format 'F:' " & SampleDateTime.ToString("F")) Debug.Print("Using Format 'f:' " & SampleDateTime.ToString("f")) Debug.Print("Using Format 'G:' " & SampleDateTime.ToString("G")) Debug.Print("Using Format 'g:' " & SampleDateTime.ToString("g")) Debug.Print("Using Format 'M:' " & SampleDateTime.ToString("M")) Debug.Print("Using Format 'm:' " & SampleDateTime.ToString("m")) Debug.Print("Using Format 'R:' " & SampleDateTime.ToString("R")) Debug.Print("Using Format 'r:' " & SampleDateTime.ToString("r")) Debug.Print("Using Format 'Y:' " & SampleDateTime.ToString("Y")) Debug.Print("Using Format 'y:' " & SampleDateTime.ToString("y")) End Sub End Class</pre> <br /> <h2> Pre-Defined Output</h2> When the project is compiled it will print the following results. <br /> <pre class="output"> Formatting Date and Time Examples: Using Format 'D:' Saturday, September 06, 2014 Using Format 'd:' 9/6/2014 Using Format 'T:' 1:14:23 PM Using Format 't:' 1:14 PM Using Format 'F:' Saturday, September 06, 2014 1:14:23 PM Using Format 'f:' Saturday, September 06, 2014 1:14 PM Using Format 'G:' 9/6/2014 1:14:23 PM Using Format 'g:' 9/6/2014 1:14 PM Using Format 'M:' September 06 Using Format 'm:' September 06 Using Format 'R:' Sat, 06 Sep 2014 13:14:23 GMT Using Format 'r:' Sat, 06 Sep 2014 13:14:23 GMT Using Format 'Y:' September, 2014 Using Format 'y:' September, 2014</pre> <br /> <h2> User-Defined Date and Time Formats</h2> The following table shows the characters you can use to create user-defined date/time formats. Unlike in earlier versions of Visual Basic, these format characters are case-sensitive. <br /> <table cellpadding="0" cellspacing="0"> <tbody> <tr><th>Character </th> <th>Description </th> </tr> <tr> <td>(:) </td> <td>Time separator. In some locales, other characters may be used to represent the time separator. The time separator separates hours, minutes, and seconds when time values are formatted. The actual character that is used as the time separator in formatted output is determined by your application's current culture value. </td> </tr> <tr> <td>(/) </td> <td>Date separator. In some locales, other characters may be used to represent the date separator. The date separator separates the day, month, and year when date values are formatted. The actual character that is used as the date separator in formatted output is determined by your application's current culture. </td> </tr> <tr> <td>(%) </td> <td>Used to indicate that the following character should be read as a single-letter format without regard to any trailing letters. Also used to indicate that a single-letter format is read as a user-defined format. See what follows for additional details. </td> </tr> <tr> <td>d </td> <td>Displays the day as a number without a leading zero (for example, 1). Use %d if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>dd </td> <td>Displays the day as a number with a leading zero (for example, 01). </td> </tr> <tr> <td>ddd </td> <td>Displays the day as an abbreviation (for example, <span class="code">Sun).</span> </td> </tr> <tr> <td>dddd </td> <td>Displays the day as a full name (for example, <span class="code">Sunday).</span> </td> </tr> <tr> <td>M </td> <td>Displays the month as a number without a leading zero (for example, January is represented as 1). Use %M if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>MM </td> <td>Displays the month as a number with a leading zero (for example, 01/12/01). </td> </tr> <tr> <td>MMM </td> <td>Displays the month as an abbreviation (for example, <span class="code">Jan).</span> </td> </tr> <tr> <td>MMMM </td> <td>Displays the month as a full month name (for example, January). </td> </tr> <tr> <td>gg </td> <td>Displays the period/era string (for example, <span class="code">A.D.).</span> </td> </tr> <tr> <td>h </td> <td>Displays the hour as a number without leading zeros using the 12-hour clock (for example, 1:15:15 PM). Use <span class="input">%h if this is the only character in your user-defined numeric format.</span> </td> </tr> <tr> <td>hh </td> <td>Displays the hour as a number with leading zeros using the 12-hour clock (for example, 01:15:15 PM). </td> </tr> <tr> <td>H </td> <td>Displays the hour as a number without leading zeros using the 24-hour clock (for example, 1:15:15). Use <span class="input">%H if this is the only character in your user-defined numeric format.</span> </td> </tr> <tr> <td>HH </td> <td>Displays the hour as a number with leading zeros using the 24-hour clock (for example, 01:15:15). </td> </tr> <tr> <td>m </td> <td>Displays the minute as a number without leading zeros (for example, 12:1:15). Use %m if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>mm </td> <td>Displays the minute as a number with leading zeros (for example, 12:01:15). </td> </tr> <tr> <td>s </td> <td>Displays the second as a number without leading zeros (for example, 12:15:5). Use %s if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>ss </td> <td>Displays the second as a number with leading zeros (for example, 12:15:05). </td> </tr> <tr> <td>f </td> <td>Displays fractions of seconds. For example <span class="input">ff displays hundredths of seconds, whereas ffff displays ten-thousandths of seconds. You may use up to seven f symbols in your user-defined format. Use %f if this is the only character in your user-defined numeric format.</span> </td> </tr> <tr> <td>t </td> <td>Uses the 12-hour clock and displays an uppercase <span class="code">A for any hour before noon; displays an uppercase P for any hour between noon and 11:59 P.M. Use %t if this is the only character in your user-defined numeric format.</span> </td> </tr> <tr> <td>tt </td> <td>For locales that use a 12-hour clock, displays an uppercase AM with any hour before noon; displays an uppercase PM with any hour between noon and 11:59 P.M. For locales that use a 24-hour clock, displays nothing. </td> </tr> <tr> <td>y </td> <td>Displays the year number (0-9) without leading zeros. Use %y if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>yy </td> <td>Displays the year in two-digit numeric format with a leading zero, if applicable. </td> </tr> <tr> <td>yyy </td> <td>Displays the year in four-digit numeric format. </td> </tr> <tr> <td>yyyy </td> <td>Displays the year in four-digit numeric format. </td> </tr> <tr> <td>z </td> <td>Displays the timezone offset without a leading zero (for example, -8). Use %z if this is the only character in your user-defined numeric format. </td> </tr> <tr> <td>zz </td> <td>Displays the timezone offset with a leading zero (for example, -08) </td> </tr> <tr> <td>zzz </td> <td>Displays the full timezone offset (for example, <span class="code">-08:00)</span> </td> </tr> </tbody> </table> <br /> <h2> User Defined Date and Time Formatting Examples</h2> Copy and Paste the following codes into your project then compile. <br /> <pre class="brush: vb"> Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim SampleDateTime As Date = #9/6/2014 1:14:23 PM# Debug.Print("User-Defined Date and Time Formatting Examples:") Debug.Print("Prints '9/6/14': " & Format(SampleDateTime, "M/d/y")) Debug.Print("Prints '6-Sep': " & Format(SampleDateTime, "d-MMM")) Debug.Print("Prints '6-Sep-14': " & Format(SampleDateTime, "d-MMM-yy")) Debug.Print("Prints '6 September': " & Format(SampleDateTime, "d MMMM")) Debug.Print("Prints 'September 14': " & Format(SampleDateTime, "MMMM yy")) Debug.Print("Prints '2014-09-06': " & Format(SampleDateTime, "yyyy-MM-dd")) Debug.Print("Prints '01:14 PM': " & Format(SampleDateTime, "hh:mm tt")) Debug.Print("Prints '1:14:23 P': " & Format(SampleDateTime, "h:mm:ss t")) Debug.Print("Prints '13:14': " & Format(SampleDateTime, "H:mm")) Debug.Print("Prints '13:14:23': " & Format(SampleDateTime, "H:mm:ss")) Debug.Print("Prints '9/6/2014 13:14': " & Format(SampleDateTime, "M/d/yyyy H:mm")) End Sub End Class</pre> <br /> <h2> User-Defined Output</h2> When the project is compile it will print the following results. <br /> <pre class="output"> User-Defined Date and Time Formatting Examples: Prints '9/6/14': 9/6/14 Prints '6-Sep': 6-Sep Prints '6-Sep-14': 6-Sep-14 Prints '6 September': 6 September Prints 'September 14': September 14 Prints '2014-09-06': 2014-09-06 Prints '01:14 PM': 01:14 PM Prints '1:14:23 P': 1:14:23 P Prints '13:14': 13:14 Prints '13:14:23': 13:14:23 Prints '9/6/2014 13:14': 9/6/2014 13:14</pre>

date vb.net dotNet VB.NET Formatting Date and Time VB.NET

The Date literal must be enclosed within number signs (#date#) and specify the date value in the format M/d/yyyy like #09/06/2014#. Else, the way how your code is interpreted may vary depending on the locale in which your application is deployed. Wit…

Read more »

Working with Date and Time VB.Net

<b>VB.NET's DateTime</b> structure represents an instant in time which is commonly expressed as a particular date and time of the day. It's a part of your daily life while creating your applications which makes it easy for you to manipulate system's date and time. In this article I'll be showing you the commonly used <b>properties</b> and <b>methods</b> and example <b>usage</b> of the Date and Time in VB.Net.<br /><br />Use the Date data type to contain date values, time values, or date and time values. The default value of Date is 0:00:00 (midnight) on January 1, 0001. You can get the current date and time from the DateAndTime class.<br /><br /><h2><b>DateTime Properties</b></h2>The table below shows some of the commonly used properties of the DateTime Structure: <table cellpadding="0" cellspacing="0"><tbody><th style="width:25%;">Property</th><th>Description</th><tr><td><b>Date</b></td><td>Gets the date component of this instance.</td></tr><tr><td><b>Day</b></td><td>Gets the day of the month represented by this instance.</td></tr><tr><td><b>DayOfWeek</b></td><td>Gets the day of the week represented by this instance.</td></tr><tr><td><b>DayOfYear</b></td><td>Gets the day of the year represented by this instance.</td></tr><tr><td><b>Hour</b></td><td>Gets the hour component of the date represented by this instance.</td></tr><tr><td><b>Kind</b></td><td>Gets a value that indicates whether the time represented by this instance is based on local time, Coordinated Universal Time (UTC), or neither.</td></tr><tr><td><b>Millisecond</b></td><td>Gets the milliseconds component of the date represented by this instance.</td></tr><tr><td><b>Minute</b></td><td>Gets the minute component of the date represented by this instance.</td></tr><tr><td><b>Month</b></td><td>Gets the month component of the date represented by this instance.</td></tr><tr><td><b>Now</b></td><td>Gets a <b>DateTime</b> object that is set to the current date and time on this computer, expressed as the local time.</td></tr><tr><td><b>Second</b></td><td>Gets the seconds component of the date represented by this instance.</td></tr><tr><td><b>Ticks</b></td><td>Gets the number of ticks that represent the date and time of this instance.</td></tr><tr><td><b>TimeOfDay</b></td><td>Gets the time of day for this instance.</td></tr><tr><td><b>Today</b></td><td>Gets the current date.</td></tr><tr><td><b>UtcNow</b></td><td>Gets a <b>DateTime</b> object that is set to the current date and time on this computer, expressed as the Coordinated Universal Time (UTC).</td></tr><tr><td><b>Year</b></td><td>Gets the year component of the date represented by this instance.</td></tr></tbody></table><br/><br/><h2>DateTime Methods</h2>The table below shows the commonly used Methods of the DateTime Structure. <table cellpadding="0" cellspacing="0"><tbody><th>Method Name</th><th>Description</th><tr><td><b>Public Function Add ( value As TimeSpan ) As DateTime</b></td><td>Returns a new DateTime that adds the value of the specified TimeSpan to the value of this instance.</td></tr><tr><td><b>Public Function AddDays ( value As Double ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of days to the value of this instance.</td></tr><tr><td><b>Public Function AddHours ( value As Double ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of hours to the value of this instance.</td></tr><tr><td><b>Public Function AddMinutes ( value As Double ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of minutes to the value of this instance.</td></tr><tr><td><b>Public Function AddMonths ( months As Integer ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of months to the value of this instance.</td></tr><tr><td><b>Public Function AddSeconds ( value As Double ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of seconds to the value of this instance.</td></tr><tr><td><b>Public Function AddYears ( value As Integer ) As DateTime</b></td><td>Returns a new DateTime that adds the specified number of years to the value of this instance.</td></tr><tr><td><b>Public Shared Function Compare ( t1 As DateTime, t2 As DateTime ) As Integer</b></td><td>Compares two instances of DateTime and returns an integer that indicates whether the first instance is earlier than, the same as, or later than the second instance.</td></tr><tr><td><b>Public Function CompareTo ( value As DateTime ) As Integer</b></td><td>Compares the value of this instance to a specified DateTime value and returns an integer that indicates whether this instance is earlier than, the same as, or later than the specified DateTime value.</td></tr><tr><td><b>Public Function Equals ( value As DateTime ) As Boolean</b></td><td>Returns a value indicating whether the value of this instance is equal to the value of the specified DateTime instance.</td></tr><tr><td><b>Public Shared Function Equals ( t1 As DateTime, t2 As DateTime ) As Boolean</b></td><td>Returns a value indicating whether two DateTime instances have the same date and time value.</td></tr><tr><td><b>Public Overrides Function ToString As String</b></td><td>Converts the value of the current DateTime object to its equivalent string representation.</td></tr></tbody></table><br/><br/><h2>DateTime Methods Example</h2>The following snippet shows some of the DateTime Methods used in the DateTime Structure. <pre class="brush: vb"><br />Public Sub DateTimeMethods()<br /> Debug.Print("Today is: " & Now)<br /> Debug.Print("Adds 1 Day to Current date: " & Now.AddDays(1))<br /> Debug.Print("Adds 1 Hour to Current Time: " & Now.AddHours(1))<br /> Debug.Print("Adds 1 Minute to Current Time: " & Now.AddMinutes(1))<br /> Debug.Print("Adds 1 Second to Current Time: " & Now.AddSeconds(1))<br />End Sub<br /></pre><br/><h2>Output</h2>The above snippet should print the following. <pre class="output"><br />Today is: 9/6/2014 11:54:31 AM<br />Adds 1 Day to Current date: 9/7/2014 11:54:31 AM<br />Adds 1 Hour to Current Time: 9/6/2014 12:54:31 PM<br />Adds 1 Minute to Current Time: 9/6/2014 11:55:31 AM<br />Adds 1 Second to Current Time: 9/6/2014 11:54:32 AM<br /></pre><br/><h2>Formatting Date and Time</h2><a href="#" title="Formatting Date and Time Tutorial">See formatting Date and Time tutorial here...</a>

date vb.net dotNet VB.NET Working with Date and Time VB.Net

VB.NET's DateTime structure represents an instant in time which is commonly expressed as a particular date and time of the day. It's a part of your daily life while creating your applications which makes it easy for you to manipulate system's date an…

Read more »

Commonly Used VBA Statements for Excel VBA Programming

The following table shows a list of commonly used VBA statements that might be useful when creating macros for your Excel projects. To know more information about each statement, consult Excel’s Help system by pressing "F1". <br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgcU5Jj1uAwQCyKRQR_VIBvHhP81iLJW8UoLzrNim7XMmJkgKQn_NkWlydLUsEBfkcSmYAEAe_iJF7qb8pqsjbz8C4ZXzRoScOOmFGH6du2zb1-CY4bWjfh036NqYF93YD6Pc51m4laZoR/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="560" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgcU5Jj1uAwQCyKRQR_VIBvHhP81iLJW8UoLzrNim7XMmJkgKQn_NkWlydLUsEBfkcSmYAEAe_iJF7qb8pqsjbz8C4ZXzRoScOOmFGH6du2zb1-CY4bWjfh036NqYF93YD6Pc51m4laZoR/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_1.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidgc0laEJwk7sh0tJTVEyUx57Lveg0gQPXSsC9P0jCNcaj1SgMLRedv2urQA_peAXPJErUftJdIoDwKLHrzDqieIc1LRSZJo67GKqF9zHe49l0-DDP4MARxtZWIEWD_LZe149NTbEd6QBA/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="539" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidgc0laEJwk7sh0tJTVEyUx57Lveg0gQPXSsC9P0jCNcaj1SgMLRedv2urQA_peAXPJErUftJdIoDwKLHrzDqieIc1LRSZJo67GKqF9zHe49l0-DDP4MARxtZWIEWD_LZe149NTbEd6QBA/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_2.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivSsKInS9ce2dAl4zh_g0parfHvPpgvKr7iMnxtTu-dNmM34NY8lydOFQ2lSG6CK0Rj6-8iNlkGXaZDfbbO_TSqnEG3VsKlYmZ6ywhJjfeeIB1EpSzNM-epCtsd80eU0Ya7sIr8USTS86V/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="539" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivSsKInS9ce2dAl4zh_g0parfHvPpgvKr7iMnxtTu-dNmM34NY8lydOFQ2lSG6CK0Rj6-8iNlkGXaZDfbbO_TSqnEG3VsKlYmZ6ywhJjfeeIB1EpSzNM-epCtsd80eU0Ya7sIr8USTS86V/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_3.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNThxGTWvWN_SvGTKZl684rXEdrBfrFQu-UlipSdTBxF6Sm1r1R6YnfWdEi5adq4jhyPcZp3oU4Pcc6kGA-vdw32StpeEAhCBDP1PGEWvQMuqwvAz2jEkZuaRwyfKEIWv9MO-1lQXiOPr6/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="539" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNThxGTWvWN_SvGTKZl684rXEdrBfrFQu-UlipSdTBxF6Sm1r1R6YnfWdEi5adq4jhyPcZp3oU4Pcc6kGA-vdw32StpeEAhCBDP1PGEWvQMuqwvAz2jEkZuaRwyfKEIWv9MO-1lQXiOPr6/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_4.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg3ckyL7AKqyMoljJbxR-WlDtT346iMX8Msx7EDpmpEvB_OBnTNnYEmhL5newulUkW2mkRLEDPUbJ-STcMEwNFntvvrAhcNS_OnDMY1rv7tsa5Q8VUNTfVkniDMbRLbcIN6g4PFzSDXMwj/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="409" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg3ckyL7AKqyMoljJbxR-WlDtT346iMX8Msx7EDpmpEvB_OBnTNnYEmhL5newulUkW2mkRLEDPUbJ-STcMEwNFntvvrAhcNS_OnDMY1rv7tsa5Q8VUNTfVkniDMbRLbcIN6g4PFzSDXMwj/s1600/Common+VBA+Statements+for+Excel+VBA+Programming_5.png" width="640" /></a></div> <br /> <br /> <br />

excel microsoft excel VBA Commonly Used VBA Statements for Excel VBA Programming

The following table shows a list of commonly used VBA statements that might be useful when creating macros for your Excel projects. To know more information about each statement, consult Excel’s Help system by pressing "F1". …

Read more »