Pinoy Tutorials, Tips and Tricks

Implement a Graph from ASCII Data to Chart Windows Form Control using VB.NET

The example below is a simple way on how to Plot a Graph in Chart Windows Form Control using VB.Net.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgftdFl7e0YawGP_TGn4YH6cUzhWKabSYMRQptbIH5mNoQWFXci5VBQQcqmkXtC74w-UWfcfLrwIQjDdw0kPXvPeNGQOIZYBFZBU8jYLt6fxU17JGUGwMvxsosFun_SGp-i6N7zCeAEd6QX/s1600/Graph.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Implement Graph on Chart Windows Form Control" border="1" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgftdFl7e0YawGP_TGn4YH6cUzhWKabSYMRQptbIH5mNoQWFXci5VBQQcqmkXtC74w-UWfcfLrwIQjDdw0kPXvPeNGQOIZYBFZBU8jYLt6fxU17JGUGwMvxsosFun_SGp-i6N7zCeAEd6QX/s400/Graph.png" title="Implement Graph on Chart Windows Form Control" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><br /><b>Requirements:</b><br />1. Microsoft Visual Studio (In my case, I'm using Visual Studio 2010 Express Edition).<br /><br /><b>To Begin with:</b><br />1. Start your Microsoft Visual Basic 2010 Express.<br />2. In the <span style="color: #3d85c6;">New Project</span> window, Choose "<span style="color: #3d85c6;">Windows Form Application</span>" and name it to whatever you like or something like "<span style="color: #3d85c6;">Plot Graph</span>" then Click "<span style="color: #3d85c6;">OK</span>".<br />3. You must now be able to see the Form. On the toolbox Add the following controls onto the form and update its properties.<br />     a. <b>Form</b>: <span style="color: #3d85c6;">Name</span>:=<span style="color: #38761d;">frmGraph </span><br />     b. (1) <b>Chart</b>: <span style="color: #3d85c6;">Name</span>:=<span style="color: #38761d;">Chart1</span><br />     c. (1) <b>Textbox</b>: <span style="color: #3d85c6;">Name</span>:=<span style="color: #38761d;">txtData</span>, <span style="color: #3d85c6;">Multiline:=<span style="color: #38761d;">True</span>, Text</span>:=<span style="color: #38761d;"><span style="font-size: small;">30;52;57;57;68;93;129;173;209;232;240;232;217;196;169;141;116;98;86;80;78;76;76;79;81;83;86;91;95;97;95;93;95;99;103;105;106;107;110;116;120;122;123;124;127;132;137;139;137;136;132;126;124;122;117;113;110;105;97</span></span><br />     d. (1) <b>Button</b>: <span style="color: #3d85c6;">Name</span>:=<span style="color: #38761d;">btnPlot</span>, <span style="color: #3d85c6;">Text</span>:=<span style="color: #38761d;">&Plot</span><br /><br /><span style="color: #45818e;">*Then arrange and re-size the controls as you can see below. But you can still orient it to whatever you want.</span><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUwDAroqj8g0I_u5G6UrSuRKrYzBzibgPB9zmaIdih49-zQON9IBJuIX9lvzVsV3BquePQHxaUnEKdP_GNwLhkCnvotkZMTi4G1l98Zg7z7sCMWwS97nzlX3aZoXFw0gq86_zdZ0Y5uwP_/s1600/Form+Controls.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Form Controls Orientation" border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUwDAroqj8g0I_u5G6UrSuRKrYzBzibgPB9zmaIdih49-zQON9IBJuIX9lvzVsV3BquePQHxaUnEKdP_GNwLhkCnvotkZMTi4G1l98Zg7z7sCMWwS97nzlX3aZoXFw0gq86_zdZ0Y5uwP_/s320/Form+Controls.jpg" title="Form Controls Orientation" width="320" /></a></div><input type="hidden" name="IL_IN_TAG" value="1"/><br />4. Now <b>Press</b> <span style="color: #3d85c6;">F7</span> to view the code editor window.<br /><br /><u><span style="font-size: small;"><span style="color: #073763;"><b>Code Blocks:</b></span></span></u><br /><br /><b>:namespace</b> - We need to <i>declare the namespace containing the methods and properties of the Chart Windows Form Control</i> in order to use its properties and methods.<br /><br /><pre class="brush: vb">Imports System.Windows.Forms.DataVisualization.Charting<br /></pre><br /><b>:frmGraph_Load()</b> - When the form is loaded we do not want to see the Gridlines behind the plot so we'll disable it by setting the MajorGrid Property of the ChartAreas X and Y Axis Enabled to False and set it background to transparent.<br /><br /><pre class="brush: vb">    Private Sub frmGraph_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />        With Chart1.ChartAreas(0)<br />            .AxisX.MajorGrid.Enabled = False<br />            .AxisY.MajorGrid.Enabled = False<br />            .AxisX.MajorGrid.LineColor = Color.Coral<br />            .AxisY.MajorGrid.LineColor = Color.Coral<br />            .BackColor = Color.Transparent<br />        End With<br />    End Sub<br /></pre><br /><b>:btnPlot_Click()</b> - When the Plot button is clicked, we declare an Array and 2 collections of series values.<br />        <b>CD</b> = An array collection that holds the data we split from the data Textbox.        <br />        <b>s1</b> = Is our first series collection<br />        <b>s2</b> = is our second series collection (Both have the same values since we only need to plot the Points and a Line.<br /><br /><pre class="brush: vb">    Private Sub btnPlot_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlot.Click<br />        Dim CD As Array<br />        Dim s1 As New Series<br />        Dim s2 As New Series<br />        Dim xLab As Long<br /><br />        'GET data from the textbox<br />        CD = Split(txtData.Text, ";", -1)<br /><br />        Chart1.Series.Clear()<br /><br />        s1.Name = "Series 1"<br />        s1.ChartType = SeriesChartType.FastPoint<br />        s2.Name = "Series 2"<br />        s2.ChartType = SeriesChartType.FastLine<br /><br />        xLab = 1<br />        'loop through each array and set series values<br />        For Each d In CD<br />            s1.Points.AddXY(xLab, d)<br />            s2.Points.AddXY(xLab, d)<br />            xLab = xLab + 1<br />        Next<br /><br />        'Add update the chart with the series values<br />        Chart1.Series.Add(s1)<br />        Chart1.Series.Add(s2)<br /><br />    End Sub<br /></pre><br /><b>Full Code:</b><br /><br /><pre class="brush: vb">Imports System.Windows.Forms.DataVisualization.Charting<br /><br />Public Class frmGraph<br /><br />    Private Sub frmGraph_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />        With Chart1.ChartAreas(0)<br />            .AxisX.MajorGrid.Enabled = False<br />            .AxisY.MajorGrid.Enabled = False<br />            .AxisX.MajorGrid.LineColor = Color.Coral<br />            .AxisY.MajorGrid.LineColor = Color.Coral<br />            .BackColor = Color.Transparent<br />        End With<br />    End Sub<br />    <br />    Private Sub btnPlot_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlot.Click<br />        Dim CD As Array<br />        Dim s1 As New Series<br />        Dim s2 As New Series<br />        Dim xLab As Long<br /><br />        'GET data from the textbox<br />        CD = Split(txtData.Text, ";", -1)<br /><br />        Chart1.Series.Clear()<br /><br />        s1.Name = "Series 1"<br />        s1.ChartType = SeriesChartType.FastPoint<br />        s2.Name = "Series 2"<br />        s2.ChartType = SeriesChartType.FastLine<br /><br />        xLab = 1<br />        'loop through each array and set series values<br />        For Each d In CD<br />            s1.Points.AddXY(xLab, d)<br />            s2.Points.AddXY(xLab, d)<br />            xLab = xLab + 1<br />        Next<br /><br />        'Add update the chart with the series values<br />        Chart1.Series.Add(s1)<br />        Chart1.Series.Add(s2)<br /><br />    End Sub<br />End Class<br /></pre><br />5. <b>Finally</b>, build and run the project.

dotNet VB.NET Implement a Graph from ASCII Data to Chart Windows Form Control using VB.NET

The example below is a simple way on how to Plot a Graph in Chart Windows Form Control using VB.Net.Requirements:1. Microsoft Visual Studio (In my case, I'm using Visual Studio 2010 Express Edition).To Begin with:1. Start your Microsoft Visual Basic …

How to Enable and Disable Macros in Microsoft Excel

10:13 PM OmelSoft 0

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiENunHpM0iiGnwtuFplpOk6zZIk8X0KJsGHMZ_DQyuaJTWE29DpRaqEWgD8gg82i91YInWCgZ1fW51D1i33mwIaKQ52vSlvLFRKWIyN8uNVIB7kT5WZnZVSWbYbUQYkGEUcyqBB8QpdJr/s1600/Security+Warning.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiENunHpM0iiGnwtuFplpOk6zZIk8X0KJsGHMZ_DQyuaJTWE29DpRaqEWgD8gg82i91YInWCgZ1fW51D1i33mwIaKQ52vSlvLFRKWIyN8uNVIB7kT5WZnZVSWbYbUQYkGEUcyqBB8QpdJr/s1600/Security+Warning.jpg" /></a></div><div style="text-align: justify;">While most macros are harmless and helpful when it comes to automating repetitive tasks. It also poses a security risks if it's coded with malicious purpose. It can contain unsafe codes that can be harmful when ran on your systems. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"></div><div style="text-align: justify;">Do make sure that you run macros that you own or from known sources and trusted publishers. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">To enable or disable and set macro security level in any office application that has VBA macros, Open the <b>Developer tab</b> or <a href="http://tutorpinoy.blogspot.com/2013/10/how-to-show-developer-tab-in-microsoft.html" target="_blank">See How to show Developer tab in Ribbon</a>. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"></div><div style="text-align: justify;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpplEwtumvBa7nU3O_ash1yu6pARiGbs5MSNL7e-eFp9oFubTTyLiuAlb5tjDdXZktPEfR8ymC_PBk9HWRNqJmRj8-ikx70tmfw2Ysll81GZhyphenhyphenfEmya6b1SIwzlCjacYoTMDKg3YO7cHBI/s1600/Trust+Center.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpplEwtumvBa7nU3O_ash1yu6pARiGbs5MSNL7e-eFp9oFubTTyLiuAlb5tjDdXZktPEfR8ymC_PBk9HWRNqJmRj8-ikx70tmfw2Ysll81GZhyphenhyphenfEmya6b1SIwzlCjacYoTMDKg3YO7cHBI/s400/Trust+Center.jpg" width="320" /></a></div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOtUZMsFNWk4iR4IycHjU4kHOFoH17adj8Lxlu2llUW8dp2gy4rXulscVohhd2I-aehuM3p-vgQAsAKT-6H3hkugxkLs38YC2HfmeACAfpsJA9-iZEb0hChCsljEVagBnlW1T7mAk-7z5x/s1600/Trust+Center.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a> <ins class="adsbygoogle" data-ad-client="ca-pub-1800470006166226" data-ad-slot="8848048043" style="display: inline-block; height: 90px; width: 200px;"></ins><script>(adsbygoogle = window.adsbygoogle || []).push({}); </script>Open up the Trust Center dialog window by clicking the <b>macro security</b> button on the <b>developer tab</b> or press (<b>Alt+LAS</b>) on your keyboard.<br /><div style="text-align: justify;"></div><br /><div style="text-align: justify;">The Macro settings tab on trust center dialog window has additional option buttons you can select to change macro level security.</div><div style="text-align: justify;"></div><div style="text-align: justify;"><br /></div><ul><li><b>Disable all macros without notification</b> - Select this option when you don't want to run all macros from unknown sources and untrusted publisher's location.</li><li>D<b>isable all macros with notification</b> (Default) - Select this option when you want to manage and check its trustworthiness before running the macro. </li></ul><span style="color: #cc0000;">If you have this option enabled, you just have to click the Options button of every security warning and select the Enable Content option button.</span><br /><ul><li><b>Disable all macros except digitally signed macros</b> - Select this option if you want to automatically run trustworthy digitally signed macros without raising notification.</li><li><b>Enable all macros (not recommend potentially dangerous code can run)</b> - Selecting this option is totally at your own risk, malicious codes can freely run and may cause damage to your system.</li></ul></div>

excel microsoft excel How to Enable and Disable Macros in Microsoft Excel

While most macros are harmless and helpful when it comes to automating repetitive tasks. It also poses a security risks if it's coded with malicious purpose. It can contain unsafe codes that can be harmful when ran on your systems. Do make sure that …

How to show the Developer Tab in Microsoft Excel 2007

8:01 PM OmelSoft 0

<div style="text-align: left;">By default, the Developer Tab is not shown on the Microsoft Excel's Ribbon.</div><div style="text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzHIdcir9xouCT0dhRr1bO_Mx_ykljZsNt2ynuCzT4mPLs1soY1Skcar7vSr-sapCFKUu2eNhRtFWYlcA66zcbjWb2Is78QshUj9eP-egKMsQHfn0P-KbCu3kk2hOZmYm3Cn36IJlunZ-3/s1600/Show+Developer+Tab.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="156" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzHIdcir9xouCT0dhRr1bO_Mx_ykljZsNt2ynuCzT4mPLs1soY1Skcar7vSr-sapCFKUu2eNhRtFWYlcA66zcbjWb2Is78QshUj9eP-egKMsQHfn0P-KbCu3kk2hOZmYm3Cn36IJlunZ-3/s640/Show+Developer+Tab.jpg" width="640" /></a></div><div style="text-align: center;"><br /></div><div style="text-align: center;">In order to show the Developer tab, Go to the File Menu and Click the <b>Excel Options</b> button.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKtkRZps99xsNJ2ReCyRbP-Eh6VZkPGReHU8Uwx8vBZFpyRkbQUDd_zZHFx_e1I9sIDFdiiJLcnJB-k3Bq5ANP3LPiRhjvKhrDFPfWjm_vobXOVlD6tkGR-rCNnV0MqcF4bJyZ-OMWa4_g/s1600/Excel+Options.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKtkRZps99xsNJ2ReCyRbP-Eh6VZkPGReHU8Uwx8vBZFpyRkbQUDd_zZHFx_e1I9sIDFdiiJLcnJB-k3Bq5ANP3LPiRhjvKhrDFPfWjm_vobXOVlD6tkGR-rCNnV0MqcF4bJyZ-OMWa4_g/s400/Excel+Options.jpg" width="281" /> </a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">On the Excel Options Window, Check the box <b>Show Developer tab in the Ribbon</b>.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlluZGpTiiu3nfpmk4iUjXJJYO41boi4sVBUOfpahY8plUm9L3V7gVexFXMfh3wFe5ycnlbxdaAwFFLz2PPlQkjQEhOXkc-u44SH8m69yGpkuMvfNv7HSWeAj_NnG-1q13unEEtyroAldc/s1600/Check+Show+Developer+Tab.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlluZGpTiiu3nfpmk4iUjXJJYO41boi4sVBUOfpahY8plUm9L3V7gVexFXMfh3wFe5ycnlbxdaAwFFLz2PPlQkjQEhOXkc-u44SH8m69yGpkuMvfNv7HSWeAj_NnG-1q13unEEtyroAldc/s320/Check+Show+Developer+Tab.jpg" width="320" /></a> </div><div class="separator" style="clear: both; text-align: center;">Then Click OK, and that should show up the Developer tab.</div>

excel microsoft excel How to show the Developer Tab in Microsoft Excel 2007

By default, the Developer Tab is not shown on the Microsoft Excel's Ribbon.In order to show the Developer tab, Go to the File Menu and Click the Excel Options button. On the Excel Options Window, Check the box Show Developer tab in the Ribbon. Then C…

The Ultimate Annual-Monthly Microsoft Excel Calendar template

11:36 PM OmelSoft 1

<div class="KonaBody"><div class="separator" style="clear: both; float: left; text-align: left;"><br /></div>This Ultimate Excel Calendar Template allows user, company or any organization to create their own calendars. The template was created in VBA and may require the user to <a href="http://tutorpinoy.blogspot.com/2013/10/how-to-enable-and-disable-macros-in.html" target="_blank">enable macro</a> content in the document. <br /><br /><b>Annual Calendar Template:</b><br /><ul><li><b>Country</b> - Choose your home country.</li><li><b>Year</b> - Calendar year</li><li><b>First Day of the Week</b> - The first day of the week to be displayed</li><li><b>First Week of The Year</b> - Determines the work week number</li></ul>The screenshot below shows the calendar of the whole year and the holidays.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOYXtU83rk30d-zBbGGO-3i_xsgyafW12whoSOMlOMPlsCjRy1-IQUtqVtbRoePzhrzYpaiSB5ndVIqay0Y9wrPvkqBe-ZahSQb-RvnoAbaMmQ5z1RPdQ2R9f4twWl-1XSQ4WJVazMBEa6/s1600/Ultimate+Annual+Calendar+Template.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOYXtU83rk30d-zBbGGO-3i_xsgyafW12whoSOMlOMPlsCjRy1-IQUtqVtbRoePzhrzYpaiSB5ndVIqay0Y9wrPvkqBe-ZahSQb-RvnoAbaMmQ5z1RPdQ2R9f4twWl-1XSQ4WJVazMBEa6/s640/Ultimate+Annual+Calendar+Template.jpg" width="640" /></a><input name="IL_IN_TAG" type="hidden" value="1" /></div><br /><br /><div style="text-align: center;">The video shows how does Ultimate Excel Calendar template work.</div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="allowfullscreen" frameborder="0" height="266" mozallowfullscreen="mozallowfullscreen" src="https://www.youtube.com/embed/Mel-nGK-yHo?feature=player_embedded" webkitallowfullscreen="webkitallowfullscreen" width="320"></iframe></div><br /><br /><b>Monthly Calendar Template:</b><br /><ul><li><b>Month</b> - Choose which Month you want to display.</li><li><b>Year</b> - Month year.</li><li><b>First Day of Week</b> -  First day of the week to be displayed.</li><li><b>Country</b> - Choose your location</li></ul>This template will display the Holiday of the Month in the respective dates.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2s1H7G-3i-1lM0EBKEXrZhlopy98-GD9VQqEMDco3ujb7Jx-YOzrS-7qTYhmr4XN16BgYlFthBeKDx0EyD6rJwd85rfc5kvOhS667ebMVuDKVMtxUD50U6GCzaL16BrgUl8l_00NyzQ0U/s1600/Ultimate+Monthly+Calendar+Template_1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="593" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2s1H7G-3i-1lM0EBKEXrZhlopy98-GD9VQqEMDco3ujb7Jx-YOzrS-7qTYhmr4XN16BgYlFthBeKDx0EyD6rJwd85rfc5kvOhS667ebMVuDKVMtxUD50U6GCzaL16BrgUl8l_00NyzQ0U/s640/Ultimate+Monthly+Calendar+Template_1.jpg" width="640" /></a></div><br />Download the <a href="https://docs.google.com/file/d/0B5TtjmHRH2vHWHJ2VzJXUVNLdkU/edit?usp=drive_web" rel="nofollow" target="_blank">Ultimate Annual-Monthly Excel Calendar</a> or post your email in the comment so I can send to you the template file. </div>

excel microsoft excel TEMPLATE The Ultimate Annual-Monthly Microsoft Excel Calendar template

This Ultimate Excel Calendar Template allows user, company or any organization to create their own calendars. The template was created in VBA and may require the user to enable macro content in the document. Annual Calendar Template:Country - Choose …

Using Nested IFError - IF - VLookUp Functions in Excel

12:04 AM OmelSoft 0

<div class="separator" style="clear: both; text-align: left;">In this example we'll be using three excel functions such as <span style="color: #b45f06;"><i><b>IFERROR</b></i></span>,<i><b><span style="color: #b45f06;"> IF</span></b></i>and <span style="color: #b45f06;"><i><b>VLOOKUP</b></i></span> functions. </div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><span style="color: #e06666; font-size: small;"><b>=IFERROR(IF(G3="","",VLOOKUP(G3,Sheet1!B:C,2,FALSE)), "No Match Found")</b></span></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_TYd4nxEPU5bBSfMwo9XxnwTGt-E2-y2xg7nkg3SUz3JPieAG1zsTqczYMYLyx2T9naaZtse2THdS1otxEVOpjeOZfLiMkKcHyeglvurs9IBfiIj1Zi6MizNcSh4wH2u_gt6rFZPUF11N/s1600/IfError-If-Vlookup.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_TYd4nxEPU5bBSfMwo9XxnwTGt-E2-y2xg7nkg3SUz3JPieAG1zsTqczYMYLyx2T9naaZtse2THdS1otxEVOpjeOZfLiMkKcHyeglvurs9IBfiIj1Zi6MizNcSh4wH2u_gt6rFZPUF11N/s1600/IfError-If-Vlookup.jpg" /></a></div><input name="IL_IN_TAG" type="hidden" value="1" /> <div class="separator" style="clear: both; text-align: left;">For this example, we'll use the above formula at Cell <span style="color: #cc0000;">"G4"</span>:</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Initially, the formula says that if the value of <b>G3</b> is blank then set the value of <b>G4</b> to blank. Otherwise, look for the lookup value (<b>ID</b>)  in the table array and return the exact match in the second column (<b>Name</b>) . If the value is not found in the array then return a message to the user.</div><ul><li> <b>IFERROR(</b><i>'Formula to Evaluate', value-if-error</i><b>)</b> - Returns the specified value "No Match Found" if the formula evaluated returns an error value.</li><li> <b>IF(</b><i>logical_test, [value_if_true], [value_if_false]</i><b>) </b>-<b> </b>Logic test is a comparison between two values (<b>G3=""</b>), test's if the value of G3 is empty. Followed by two arguments which are the <i>value_if_true</i> and <i>value_if_false</i>.  If the value of G3 is equal to blank then do nothing or set the Cell's  value to blank. While, if the value if G3 is not equal to blank then  evaluate the next function.</li><li><b>VLOOKUP(</b><i>lookup_value, table_array, col_index_num, [range_lookup]</i><b>)</b> - Looks up  the value of <b>G3</b> in the table array <b>Sheet1!B:C</b> and return the value of the exact match from the column <b>2</b>.</li></ul>

excel microsoft excel Using Nested IFError - IF - VLookUp Functions in Excel

In this example we'll be using three excel functions such as IFERROR, IFand VLOOKUP functions. =IFERROR(IF(G3="","",VLOOKUP(G3,Sheet1!B:C,2,FALSE)), "No Match Found") For this example, we'll use the above formula at Cell "G4":Initially, the formula s…

Adding Menu's, Sub-Menus and Menu Separator at Design Time in Visual Basic 6

1:45 AM OmelSoft 0

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtlJH7xva-qZa8gb5A49nsBUrEV0IL984vo1UJM8cKh5sTN0S8SjIhZ6iRgUXI0Vjg2OdlMii80vQEXH4DFUD-CqA6qO1_AVF_LjXQFj5xLjgivl1BgtslmkOzGToIXLWNiOHy626gI_o/s1600/Adding+Menu+in+VB6.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Adding Menu's, sub-menus and menu separator in Visual Basic 6 " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtlJH7xva-qZa8gb5A49nsBUrEV0IL984vo1UJM8cKh5sTN0S8SjIhZ6iRgUXI0Vjg2OdlMii80vQEXH4DFUD-CqA6qO1_AVF_LjXQFj5xLjgivl1BgtslmkOzGToIXLWNiOHy626gI_o/s1600/Adding+Menu+in+VB6.jpg" title="Adding Menu's, sub-menus and menu separator in Visual Basic 6 " /></a></div>
This is a quick guide for beginners on how to add Menu, Sub-Menu and Menu Separator at Design Time in VB6 Project.<br />
<br />
To do this, Open up your Microsoft Visual Basic and start a New Standard EXE Project that will automatically create a form named Form1.<br />
<ul>
</ul>
Just follow the steps below or download the example <a href="http://www.2shared.com/file/QWjq7Cdo/Adding_Menu_in_VB6.html" rel="nofollow" target="_blank">here</a>.<br />
<br />
<br />
<br />
<br />
<br />
1.) First, right click on form then choose <b>Menu Editor</b> or Press <b>Ctrl+E</b>.<br />
2.) On the Menu Editor, add a <b>Main Menu</b> Caption like "File" and give it a name like "nFile" then click Next.<br />
3.) Click the right arrow button to add a menu under the main menu "File".<br />
4.) Now create the <b>First Level Menu</b> and give it a Caption like "Record" and a name like "mRecord".<br />
5.) Now to create a <b>Sub-Menu</b> for the menu Record, click the next button and the arrow button. As you can see in the list below that it is nested.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYRrOXYtP_ThqIT44zBXjc6p1cyY7lzShS8KopdqzMXDPRLCRqbZYksRqPJ0-blObOAJJcFVxIsS42NGFhoIfk5soTKKPsVGmuwiAR_VSl1Kx35KFVlmqOjGt14b5jD1EDXK8yhwEk_kQ/s1600/My+First+Sub-Menu+2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYRrOXYtP_ThqIT44zBXjc6p1cyY7lzShS8KopdqzMXDPRLCRqbZYksRqPJ0-blObOAJJcFVxIsS42NGFhoIfk5soTKKPsVGmuwiAR_VSl1Kx35KFVlmqOjGt14b5jD1EDXK8yhwEk_kQ/s320/My+First+Sub-Menu+2.jpg" width="316" /></a></div>
<div style="text-align: center;">
<b>Note: </b>You can use the arrows to move your menus up, down, left or right.</div>
6.) Now to create the <b>Menu Separator</b>, just click next and give a Caption "<b>-</b>" and a name "mSep".<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizd3WuMUU_YWTGAyPnAjKEdHwm0lNJtjU-R_oWcp9zf5VNuw-dwZHtj-MdAyQpuJ0H9UcriBrt56yQzyRi4w9IPd6QgxajD_XraE51_Wt9xqQ5Lk7Lc-4sxFlaUdtwwisPJJKKlyNcBmU/s1600/Menu+Separator+2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizd3WuMUU_YWTGAyPnAjKEdHwm0lNJtjU-R_oWcp9zf5VNuw-dwZHtj-MdAyQpuJ0H9UcriBrt56yQzyRi4w9IPd6QgxajD_XraE51_Wt9xqQ5Lk7Lc-4sxFlaUdtwwisPJJKKlyNcBmU/s320/Menu+Separator+2.jpg" width="316" /></a></div>
<br />
<br />
<br />
<ul>
</ul>

VB6 visual basic Adding Menu's, Sub-Menus and Menu Separator at Design Time in Visual Basic 6

This is a quick guide for beginners on how to add Menu, Sub-Menu and Menu Separator at Design Time in VB6 Project. To do this, Open up your Microsoft Visual Basic and start a New Standard EXE Project that will automatically create a form named Form1…

Move a border-less Form or Control in Visual Basic 6

11:36 PM OmelSoft 3

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3QetcoKxE-ij6a1aQXa7Ro-juL5TPT0vwc4f1h1U-UQOgMG3U3Cl1VG8x8AyOP44QI2IzckscaGM_X-N6loyIEaE1qWm9B8HgzGmQRJjw80f2epxQo65dx0jPCxG_Ngg5aEqyUMhAJ20/s1600/Border+Less+Window.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="43" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3QetcoKxE-ij6a1aQXa7Ro-juL5TPT0vwc4f1h1U-UQOgMG3U3Cl1VG8x8AyOP44QI2IzckscaGM_X-N6loyIEaE1qWm9B8HgzGmQRJjw80f2epxQo65dx0jPCxG_Ngg5aEqyUMhAJ20/s640/Border+Less+Window.jpg" width="400" /></a></div>
<br />
The following codes allows you to drag or move a border-less Form or Control in Visual Basic 6. This also works on other controls like <i>Label</i>,<i> Image</i> or <i>Picture Box</i>. You can also move or drag a control inside a form.<br />
<br />
Copy and Paste the code below in a Standard Module.<br />
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long  
 Declare Sub ReleaseCapture Lib "user32" ()  
 Public Const WM_NCLBUTTONDOWN = &HA1  
 Public Const HTCAPTION = 2  
</code></pre>
<br />
Then Copy and Paste the code below on a Form or Controls <span style="color: #38761d;"><b>MouseDown</b></span> Event.<br />
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> Private Sub Form_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)  
     Dim ReturnValue As Long  
     If Button = 1 Then  
     Call ReleaseCapture  
     ReturnValue = SendMessage(Me.hWnd, WM_NCLBUTTONDOWN, HTCAPTION, 0&)  
     End If  
 End Sub  
</code></pre>
<br />
<br /></div>

hot VB6 Move a border-less Form or Control in Visual Basic 6

The following codes allows you to drag or move a border-less Form or Control in Visual Basic 6. This also works on other controls like Label, Image or Picture Box. You can also move or drag a control inside a form. Copy and Paste the code below in a…

Quick and Easy Screen Capture with FastStone Capture

10:02 PM OmelSoft 0

Are you doing office works and creating a bunch of reports and another thing your doing is to create a snapshot or capture a portion or part of your screen or window of an app?<br />
<br />
<span style="color: #3d85c6;"><b>This tool is what you need it for! </b></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.faststone.org/Images/CapturePanel.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="288" src="http://www.faststone.org/Images/CapturePanel.gif" width="320" /></a></div>
<span style="font-size: large;"><span style="color: #0b5394;"><b>Publisher's Description</b></span></span><br />
<hr />
<span style="font-family: Verdana; font-size: x-small;"><b>FastStone Capture </b> is a
        powerful, lightweight, yet full-featured
        <span style="color: blue;"> screen capture tool</span> and <span style="color: blue;"> screen video
        recorder</span>. It allows you to easily capture and annotate 
anything on the screen including windows, objects, menus, full screen,
        rectangular / freehand / fixed regions as well as scrolling 
windows /
        web pages. It also allows you to record all screen activities 
including onscreen changes, speech from microphone, mouse movements and 
clicks into highly compressed video files. You can choose to send 
captures to editor, file, clipboard, printer, email,
        Word / PowerPoint document or upload them to your website. 
Editing tools include annotating (texts, arrowed lines, highlights), 
resizing, cropping, sharpening, watermarking, applying edge effects and 
many more. Other features include image scanning, global hotkeys, 
automatic filename generation, support for external editors, a color 
picker, a screen magnifier and a screen ruler.<br />
        <br />
        FastStone Capture saves files in BMP, GIF, JPEG, PCX, PNG, TGA, TIFF and PDF
formats.</span><br />
<hr />
<br />
I've been using this app for over a year to create a detailed explanation to colleagues, create tutorial, capture image from the web and many more! <br />
<br />
FastStone Capture also has a portable zipped file that includes all required files to run the application independently which can be downloaded <a href="http://www.faststonesoft.net/DN/FSCapture75.zip" rel="nofollow" target="_blank">here</a>. Read more details about <a href="http://www.faststone.org/FSCaptureDetail.htm" rel="nofollow" target="_blank">FastStone Capture</a>.<br />
<br />
<br />

windows apps Quick and Easy Screen Capture with FastStone Capture

Are you doing office works and creating a bunch of reports and another thing your doing is to create a snapshot or capture a portion or part of your screen or window of an app? This tool is what you need it for! Publisher's Description FastStone Cap…

Prevent Autorun.inf Virus from running in your Computer

7:09 PM OmelSoft 0

<b>Autorun.inf</b> is mostly used by hackers to run and spread malicious software or malwares and viruses in computers. Most people especially those who are not so familiar with this type of file are victimized.<br />
<br />
In my own experience when I was surfing the net in an Internet Cafe and plugged in my USB Drive to the PC I was using. I was there to do some research and surfing other stuffs without any problem. Later on when I went home and plugged in my USB Drive into my PC I've noticed that all folder's and documents on my USB were all gone but found out that those was just hidden.<br />
<br />
And when I was able to retrieve back all files and documents I've noticed this "<b>Autorun.inf</b>" folder in my USB. I tried to delete the folder but failed because it's having a read-only attribute.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
So here's what I did:<br />
1.) Open "<span style="color: #38761d;"><b>Run</b></span>", type in "<span style="color: #38761d;"><b>cmd</b></span>". To open the command prompt window.<br />
2.) In the Command Prompt window, type in the Drive letter of the USB removable drive followed with colon e.g. ( <span style="color: #38761d;"><b>E:</b></span> ). You can check the drive letter in "<b>My Computer</b>".<br />
3.) Type in <span style="color: #38761d;"><b>attrib -r -h -s "Autorun.inf"</b><span style="color: black;">,</span><b> </b></span>to clear all attributes of the "Autorun.inf" file.<br />
4.) Type in <span style="color: #38761d;"><b>erase Autorun.inf</b></span>, to completely delete the file.<br />
<br />
And that doesn't end there. <span style="color: #cc0000;"><i>To prevent hackers or other malwares putting this file into your machine we need to create a replica of the <b>autorun.inf</b> file</i>. </span><br />
To do this, we need to create a folder also named <span style="color: #cc0000;"><b>autorun.inf</b></span> and set read-only and hidden attribute and make sure and remember not to delete this folder by yourself. Otherwise, your USB drive might get infected by the autorun.inf virus again. <br />
<br />
1.) In the command prompt window, type in <span style="color: #38761d;"><b>md autorun.inf </b></span>to create the directory or folder.<br />
2.) Type in <span style="color: #38761d;"><b>attrib +r +h +s autorun.inf /s /d</b></span> , to set a read-only, hidden and system attribute of  the folder.<br />
<br />
<i><b>You can also do this on your local hard drives.</b></i><br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLHy_b1gOHIqx396ovCCFB6wgpJqp5exh9WEfLavHM2LPBpc76ypdB7TUStZCA1z42nYjicpZnvStBCFDZ_MxzE_WQgi4pWBh6ol794Y4Oq_OOfBzWNng4X7gb8BnBNWvLeez2tHUfyM/s1600/Autorun.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLHy_b1gOHIqx396ovCCFB6wgpJqp5exh9WEfLavHM2LPBpc76ypdB7TUStZCA1z42nYjicpZnvStBCFDZ_MxzE_WQgi4pWBh6ol794Y4Oq_OOfBzWNng4X7gb8BnBNWvLeez2tHUfyM/s320/Autorun.jpg" width="320" /></a>The purpose of doing this is that windows won't allow having a file with the same file name in one directory. So if malware's tries to put the autrorun.inf on your USB or hard drives, it will not be created because we already have the folder also named as autorun.inf. <br />
<br />

tips and tricks windows tricks Prevent Autorun.inf Virus from running in your Computer

Autorun.inf is mostly used by hackers to run and spread malicious software or malwares and viruses in computers. Most people especially those who are not so familiar with this type of file are victimized. In my own experience when I was surfing the n…

Tricks on how to set an image background of folders in Windows XP/Vista/7

5:47 AM OmelSoft 0

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLcHCc1cyEje4vniVnBq9EhGGHuvJe0Eea6HsawLMvK15QA_707IQbyHelYCY29oULvUn8_kz6ME19iXGscSUbG1MqLTKlF6Ho43hH1drx1ij7yIMbp7cKmXLFXH5VCAz6qXR9GrzHGEA/s1600/Folder+Background_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLcHCc1cyEje4vniVnBq9EhGGHuvJe0Eea6HsawLMvK15QA_707IQbyHelYCY29oULvUn8_kz6ME19iXGscSUbG1MqLTKlF6Ho43hH1drx1ij7yIMbp7cKmXLFXH5VCAz6qXR9GrzHGEA/s320/Folder+Background_2.png" width="320" /></a></div>
Have you ever wanted to customize the background of any folders in Windows XP/Vista/7?<br />
<br />
This trick will allow you to add a custom image background on your personal folders.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
1.) Choose the folder you want to customize.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOBfdbG-61V2-0NGvJ_fXBWID0sIGYsYyiTjGyjBeBBeatrW-LSTPFiwQ1O8AUpr-qC3f3-ElcAj77jnyGq-a6sfPODaiwUrgUh-yc4y6CrDakbRVcwar01Tx1rb2ogr88LJ7lFu0xT8Y/s1600/Address.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="20" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOBfdbG-61V2-0NGvJ_fXBWID0sIGYsYyiTjGyjBeBBeatrW-LSTPFiwQ1O8AUpr-qC3f3-ElcAj77jnyGq-a6sfPODaiwUrgUh-yc4y6CrDakbRVcwar01Tx1rb2ogr88LJ7lFu0xT8Y/s640/Address.png" width="640" /></a></div>
2.) Save the image you want to set as background in the folder. Or you may also use the image file in a specific location.<br />
3.) Open <b>"Notepad"</b> and paste the code below then save as <b>"desktop.ini"</b> inside the folder.<br />
<blockquote class="tr_bq">
    [{BE098140-A513-11D0-A3A4-00C04FD706EC}]<br />
    iconarea_image=Mustang-Monster-HD-Wallpapers.jpg<br />
    iconarea_text=3407871</blockquote>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s1600/desktop.png" style="margin-left: 1em; margin-right: 1em;"></a> <br />
<b>*Note:</b> <i><span style="color: #38761d;">Make sure you type the exact location of the image file. If you save 
the image inside the folder then just type the filename and the exact 
image extension. </span></i><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s1600/desktop.png" style="margin-left: 1em; margin-right: 1em;"><img alt="desktop configuration settings" border="0" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s640/desktop.png" title="desktop configuration settings" width="640" /></a> <br />
4.) Open "<b>Run</b>" and type "<b>cmd</b>".<br />
5.) Now, we're gonna <i>set the system file attribute</i> of the folder we want to customize.<br />
    On the command prompt window, type <b><span style="color: #38761d;"><i>attrib +s "<<span style="color: #cc0000;">folder address</span>>" /s /d</i></span></b> then press <b>Enter</b>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLub004eZnh7w70DjaX60L-b5QEwjCkI7rGznjd95y9JFhrpqUt-PpRfzjrdm-ptSCrAaEcx2H1jKS2h4nAW-nrp7sOpO0KZmngAgqVOCagKMDD_kraWOg4QiboTyM3kH8zBY-3Sqahxc/s1600/set+system+attribute.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLub004eZnh7w70DjaX60L-b5QEwjCkI7rGznjd95y9JFhrpqUt-PpRfzjrdm-ptSCrAaEcx2H1jKS2h4nAW-nrp7sOpO0KZmngAgqVOCagKMDD_kraWOg4QiboTyM3kH8zBY-3Sqahxc/s640/set+system+attribute.png" width="640" /></a></div>
6.) Navigate to the folder and hit Refresh.<br />
<br />
<span style="color: #f1c232;"><span style="font-family: "Trebuchet MS",sans-serif;"><b>That's it! You've got it! Enjoy!</b></span></span></div>

hot tips and tricks Tricks on how to set an image background of folders in Windows XP/Vista/7

Have you ever wanted to customize the background of any folders in Windows XP/Vista/7? This trick will allow you to add a custom image background on your personal folders. 1.) Choose the folder you want to customize. 2.) Save the image you want to s…

Excel VLOOKUP Function Tutorial

4:01 PM OmelSoft 0

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want it to be dynamic the VLOOKUP/HLOOKUP functions are very useful for you. The VLOOKUP function looks up value in columns while HLOOKUP does in rows.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><br /> This example has two sheets "Price_List" and "Orders" for mobile brands. <br />*Note: The values given are not the actual market prices.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s1600/price+list.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s400/price+list.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>The "Price_List" sheet has three columns ID, Model and Price. This is where we'll be looking up the prices value for every orders made.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s400/lookup_formula.png" width="400" /></a></div><br />Now, on the orders tab we have 3 orders made. We'll add the VLOOKUP function in the Total Price formula. This formula <span style="color: #6fa8dc;"><b>"=VLOOKUP(B2,Price_List!B1:C7,2,FALSE)"</b></span> will LOOKUP for the price of the unit brand in the Price_List Sheet.<br /><br /><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span style="color: #9fc5e8; font-size: x-small;"><b>=IF(C2<>"",VLOOKUP(B2,Price_List!B1:C7,2,FALSE) *C2,VLOOKUP(B2,Price_List!B1:C7,2,FALSE))</b></span></td></tr></tbody></table><span style="font-size: small;">The formula above is a </span><i>logical condition</i> to calculate the <b>Total Price</b> when the quantity is entered.<br /><i>The condition is:</i><br /><blockquote class="tr_bq">If the quantity <b>"C2"</b> is blank then it will just <b>lookup the unit price from the Price_List Sheet</b>. And if the quantity is entered it will <b>calculate by multiplying the unit price with the quantity value</b>.</blockquote><br />

excel Excel VLookup Tutorial microsoft excel Excel VLOOKUP Function Tutorial

How to use the VLOOKUP Function in Microsoft Excel

4:01 PM OmelSoft 0

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want it to be dynamic the VLOOKUP/HLOOKUP functions are very useful for you. The VLOOKUP function looks up value in columns while HLOOKUP does in rows.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
 This example has two sheets "Price_List" and "Orders" for mobile brands. <br />
*Note: The values given are not the actual market prices.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s1600/price+list.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s400/price+list.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
The "Price_List" sheet has three columns ID, Model and Price. This is where we'll be looking up the prices value for every orders made.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s400/lookup_formula.png" width="400" /></a></div>
<br />
Now, on the orders tab we have 3 orders made. We'll add the VLOOKUP function in the Total Price formula. This formula <span style="color: #6fa8dc;"><b>"=VLOOKUP(B2,Price_List!B1:C7,2,FALSE)"</b></span> will LOOKUP for the price of the unit brand in the Price_List Sheet.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="color: #9fc5e8; font-size: x-small;"><b>=IF(C2<>"",VLOOKUP(B2,Price_List!B1:C7,2,FALSE) *C2,VLOOKUP(B2,Price_List!B1:C7,2,FALSE))</b></span></td></tr>
</tbody></table>
<span style="font-size: small;">The formula above is a </span><i>logical condition</i> to calculate the <b>Total Price</b> when the quantity is entered.<br />
<i>The condition is:</i><br />
<blockquote class="tr_bq">
If the quantity <b>"C2"</b> is blank then it will just <b>lookup the unit price from the Price_List Sheet</b>. And if the quantity is entered it will <b>calculate by multiplying the unit price with the quantity value</b>.</blockquote>
<br />

excel microsoft excel VLookup Function How to use the VLOOKUP Function in Microsoft Excel

Keyascii Code Generator in VB6

10:13 PM OmelSoft 0

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4xAzOm0dcrw-kQVvTX8WQYmltnMw51B7CZnhuzXGkZQE5_cE8_Gosl7vO_UHicIi2Ey4TpySqVXAmlG9rLtWMAIdYMHQV8eXojLoJ0x0QyUCDeNdMIOWuGNezf1l2AzIuFvwZYUAC2pk/s1600/keyascii+code+generator+omelsoft.blogspot.com.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4xAzOm0dcrw-kQVvTX8WQYmltnMw51B7CZnhuzXGkZQE5_cE8_Gosl7vO_UHicIi2Ey4TpySqVXAmlG9rLtWMAIdYMHQV8eXojLoJ0x0QyUCDeNdMIOWuGNezf1l2AzIuFvwZYUAC2pk/s1600/keyascii+code+generator+omelsoft.blogspot.com.jpg" /></a></div>
This application allows you get the equivalent KeyAscii Value for every key you'll press on your keyboard.<br />
<br />
Just click on the <b>"Change Me!"</b> and start pressing any key on your keyboard.<br />
The <b>Character Box</b> will display the key you just pressed.<br />
And the <b>ASCII Code</b> box will display the keyascii value of the key you pressed.<br />
<br />
Download the <a href="https://docs.google.com/file/d/0B0iwfClwecjZNThRcXZocHc1UDQ/edit?usp=sharing" target="_blank"><b>KeyAscii Code Generator</b></a> sample program. </div>

hot VB6 Keyascii Code Generator in VB6

This application allows you get the equivalent KeyAscii Value for every key you'll press on your keyboard. Just click on the "Change Me!" and start pressing any key on your keyboard. The Character Box will display the key you just pressed. And the A…

How to enable Mouse Wheel Scrolling in VB6

6:41 PM OmelSoft 0

<div dir="ltr" style="text-align: left;" trbidi="on">
This article will guide you through on how to enable <b>Mouse Wheel Scrolling in VB6</b>.<br />
<br />
1. You need to download the <b><a href="http://download.microsoft.com/download/e/f/b/efb39198-7c59-4ace-a5c4-8f0f88e00d34/VB6MouseWheel.EXE" rel="nofollow" target="_blank">Microsoft's VB6 Mouse Wheel Addin</a>.</b> <br />
2. Run the <b>Self-Cabinet Extractor and Unzip</b> the necessary files.<br />
   You may change the destination to accessible location "C:\vb6mwfix".<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdVqV7DE07uvCtW48uXsWEi3fg89SKf352HQBWklcsIw4dheCGmgezpqOcTXeaAXuZXGgVoWZqUrpktypqqlxFZsilRuL0p5vqGrH__i86mPb9MyqeqWXm3DwecJZN3qOv2uHbjTLOiu4/s1600/vb6mousewheelfix_unzip.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdVqV7DE07uvCtW48uXsWEi3fg89SKf352HQBWklcsIw4dheCGmgezpqOcTXeaAXuZXGgVoWZqUrpktypqqlxFZsilRuL0p5vqGrH__i86mPb9MyqeqWXm3DwecJZN3qOv2uHbjTLOiu4/s320/vb6mousewheelfix_unzip.png" width="320" /></a></div>
<span id="goog_1852590735"></span><span id="goog_1852590736"></span><br />
3. Open "<b>Run</b>", copy and paste this code "<b><i>xcopy C:\vb6mwfix\VB6IDEMouseWheelAddin.dll %windir%\system32\VB6IDEMouseWheelAddin.dll</i></b>" without "<i>qoutes</i>".<br />
4. Press "<b>F</b>" to confirm the destination as file.<br />
5. Open "<b>Run</b>", copy and paste this code "<i><b>regsvr32 %windir%\system32\VB6IDEMouseWheelAddin.dll</b></i>" without "<i>qoutes</i>" to register the add-in.<br />
6. Open the <b>"VBA Mouse Wheel Fix.reg</b>" located on the folder where you extract the files to add the addin information in the registry.<br />
7. Start your <b>Microsoft Visual Basic 6.0</b>.<br />
8. Open <b>Add-Ins Manager.</b><br />
   <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_QsZPHVWifQOjdkXtDcy6kHrqo_cwnoKhe6L9kxLTwFoyPt1DVnNJhTSKnAyYQJ_lDKUc-1JOd6m6szQ8lOi-ZWeUA8Ebt1CdZFqV4xexC_e9_YNmRLxpFuMKVnnHv3iL5h2Uyv4GM2Y/s1600/vb6mousewheelfix_addin.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_QsZPHVWifQOjdkXtDcy6kHrqo_cwnoKhe6L9kxLTwFoyPt1DVnNJhTSKnAyYQJ_lDKUc-1JOd6m6szQ8lOi-ZWeUA8Ebt1CdZFqV4xexC_e9_YNmRLxpFuMKVnnHv3iL5h2Uyv4GM2Y/s1600/vb6mousewheelfix_addin.png" /></a></div>
<br />
9. Select "<b>MouseWheelFix</b>" in the available Add-Ins and check "<b>Loaded/Unloaded</b>" and "<b>Load on Startup</b>" on the load behavior.<br />
   <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ6Wh_mLl0ySxaq-NWz2cw7KVdcB1J3joFUUg4MfEMCp_T498_INVALg3T-yVkxDP9GG79Ewt2X3iX_tyLKmYt3G3CqHUZdCDkjtItY9zYB1wKlbA6JXoCcgXKSuuS6OKnBB097vy-8Wg/s1600/vb6mousewheelfix_startup_loaded.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ6Wh_mLl0ySxaq-NWz2cw7KVdcB1J3joFUUg4MfEMCp_T498_INVALg3T-yVkxDP9GG79Ewt2X3iX_tyLKmYt3G3CqHUZdCDkjtItY9zYB1wKlbA6JXoCcgXKSuuS6OKnBB097vy-8Wg/s320/vb6mousewheelfix_startup_loaded.png" width="320" /></a></div>
<br />
10. Restart Microsoft Visual Basic 6.0 in order the changes to take effect.<br />
<br /></div>

Add-Ins hot VB6 How to enable Mouse Wheel Scrolling in VB6

This article will guide you through on how to enable Mouse Wheel Scrolling in VB6. 1. You need to download the Microsoft's VB6 Mouse Wheel Addin. 2. Run the Self-Cabinet Extractor and Unzip the necessary files. You may change the destination to …

Make an application on top of another window in VB6

6:33 PM OmelSoft 0

Maintaining an application on top of other applications, regardless if they were present on the screen or are called later is.<br />
<br />
VB6: Maintaining an application over the others<br />
    * In a general module<br />
    * In the opening form<br />
    * Calling the function<br />
    * Removing priority<br />
<br />
Copy and paste this in a General Module.<br />
<blockquote class="tr_bq">
Public Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal_<br />
    hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As _<br />
    Long, ByVal cy As Long, ByVal wFlags As Long) As Long<br />
<br />
Public Const HWND_TOPMOST = -1<br />
Public Const HWND_NOTOPMOST = -2<br />
Public Const SWP_NOACTIVATE = &H10<br />
Public Const SWP_SHOWWINDOW = &H40<br />
Public Const SWP_NOMOVE = 2<br />
Public Const SWP_NOSIZE = 1</blockquote>
Put this in your form. <br />
<br />
<blockquote class="tr_bq">
Private Sub Form_Load()<br />
    Dim R as long<br />
    R = SetWindowPos(SheetName.hwnd, HWND_TOPMOST, 0, 0, 0, 0, SWP_NOMOVE Or SWP_NOSIZE)<br />
End sub
</blockquote>
<br />
Calling the function
<br />
The function must be put in the activation of the form, which will allow to resume this function if the form is selected (as the function may be used by other application).<br />
<br />
<blockquote class="tr_bq">
Private Sub Form_Activate()<br />
    Dim R as long<br />
    R = SetWindowPos(SheetName.hwnd, HWND_TOPMOST, 0, 0, 0, 0, SWP_NOMOVE Or SWP_NOSIZE)<br />
End sub
</blockquote>
<br />
<br />
Removing priority<br />
<blockquote class="tr_bq">
Private sub SuppPriority()<br />
    Dim R as long<br />
    R= SetWindowPos(NomFeuille.hwnd, HWND_NOTOPMOST, 0, 0, 0, 0, SWP_NOMOVE Or SWP_NOSIZE)<br />
End sub</blockquote>

advance vb6 visual basic Make an application on top of another window in VB6

Maintaining an application on top of other applications, regardless if they were present on the screen or are called later is. VB6: Maintaining an application over the others * In a general module * In the opening form * Calling the funct…

Compact a JET database using ADO in VB6

6:21 PM OmelSoft 0

The following routines demonstrates how to compact a JET database using ADO:<br />
<br />
<blockquote class="tr_bq">
Option Explicit<br />
<br />
'Purpose     :  Compact a JET (Access) database using ADO<br />
'Inputs      :  sDatabasePath                   The path to the database path eg. C:\nwind.mdb<br />
'               [bEncryptDatabase]              If True, encrypts the contents of the database<br />
'Outputs     :  Returns zero if successful, else returns error code<br />
'Notes       :  Requires "Microsoft Jet and Replication Objects X.X library",<br />
'               where (X.X is greater than or equal to 2.1)<br />
'               Compacts the database by creating a temporary database with the extension .tmp then,<br />
'               if the compaction is successful, it overwrites the original database.<br />
'               Will not work if anyone else is connected to the database.<br />
'Revisions   :<br />
'Assumptions :<br />
<br />
Function DatabaseCompact(sDatabasePath As String, Optional bEncryptDatabase As Boolean = False) As Long<br />
    Dim oJRO As Object 'JRO.JetEngine<br />
<br />
    On Error GoTo ErrFailed<br />
    <br />
    If Len(Dir$(sDatabasePath & ".tmp")) Then<br />
        'Delete the existing temp database<br />
        VBA.Kill sDatabasePath & ".tmp"<br />
    End If<br />
    <br />
    Set oJRO = CreateObject("JRO.JetEngine")<br />
    <br />
    If bEncryptDatabase Then<br />
        'Compact and encrypt the database<br />
        oJRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDatabasePath, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDatabasePath & ".tmp;Jet OLEDB:Encrypt Database=True"<br />
    Else<br />
        'Compact the database<br />
        oJRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDatabasePath, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDatabasePath & ".tmp;Jet OLEDB:Engine Type=4"<br />
    End If<br />
    <br />
    'Delete the existing database<br />
    VBA.Kill sDatabasePath<br />
    'Rename the compacted database<br />
    Name sDatabasePath & ".tmp" As sDatabasePath<br />
    Set oJRO = Nothing<br />
<br />
    Exit Function<br />
<br />
ErrFailed:<br />
    Debug.Print "Failed to compact database: " & Err.Description<br />
    DatabaseCompact = Err.Number<br />
    Set oJRO = Nothing<br />
    On Error GoTo 0<br />
End Function<br />
<br />
'Demonstration routine<br />
Sub Test()<br />
    Dim lRes As Long<br />
    On Error Resume Next<br />
    lRes = DatabaseCompact("C:\test.mdb", True)<br />
    If lRes = 0 Then<br />
        MsgBox "Succeeded in compacting database...", vbInformation<br />
    Else<br />
        'Show error message<br />
        MsgBox Error(lRes)<br />
    End If<br />
    Exit Sub<br />
ErrFailed:<br />
    MsgBox Err.Description<br />
End Sub</blockquote>

access database ado jet database visual basic Compact a JET database using ADO in VB6

The following routines demonstrates how to compact a JET database using ADO: Option Explicit 'Purpose : Compact a JET (Access) database using ADO 'Inputs : sDatabasePath The path to the database path eg. C:\nwind.mdb ' …

Open an External File, URL, Email and System Apps in VB6

6:18 AM OmelSoft 1

<div>
The <b><i>ShellExecute</i></b> function allows you to open external application, specific URL location, email address or launch system applications upon clicking on a single button.<br />
<br />
1. Start a new <b>Standard Exe</b> Project.<br />
2. Add this code in <b>General Declarations</b>.<br />
<blockquote class="tr_bq">
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long</blockquote>
3. Add a command button on your form, change its name to <b>cmdOpen.</b><br />
4. DoubleClick on the form and try any of the codes below.</div>
<br />
<blockquote class="tr_bq">
<br />
'# Open file (quotes are used so that the actual value that is passed is "C:\test.txt"<br />
Private Sub cmdOpen_Click()<br />
    ShellExecute 0, vbNullString, """"C:\test.txt"""", vbNullString, vbNullString, vbNormalFocus<br />
End Sub<br />
'# Open url<br />
Private Sub cmdOpen_Click()<br />
    ShellExecute 0, vbNullString, "http://omelsoft.blogspot.com", vbNullString, vbNullString, vbNormalFocus<br />
End Sub<br />
'# Open email address<br />
Private Sub cmdOpen_Click()<br />
    ShellExecute 0, vbNullString, "mailto:omelsoft@gmail.com", vbNullString, vbNullString, vbNormalFocus<br />
End Sub<br />
'#Open System Apps<br />
Private Sub cmdOpen_Click()<br />
    ShellExecute 0, vbNullString, "Notepad", vbNullString, vbNullString, vbNormalFocus<br />
End Sub</blockquote>

shell shell execute system apps vb6 visual basic Open an External File, URL, Email and System Apps in VB6

The ShellExecute function allows you to open external application, specific URL location, email address or launch system applications upon clicking on a single button. 1. Start a new Standard Exe Project. 2. Add this code in General Declarations. Pr…

Auto-adjust Column Width of a Listview Control in VB6

5:52 AM OmelSoft 0

auto adjust column listview control visual basic Auto-adjust Column Width of a Listview Control in VB6

The following function auto adjusts column width of listview controls in vb6. Just copy and paste the code below on your project and call the function after loading data on your listview control. Private Declare Function SendMessage Lib "user32" Ali…

VB KeyAscii Code and Values

5:31 AM OmelSoft 1

<div dir="ltr" style="text-align: left;" trbidi="on">
<i>Visual Basic KeyAscii Values</i> can range from 0 to 255.  Here is a chart which shows all possible KeyAscii values along with the character which they represent.To type out any of these characters without pressing the actual character you can do this.Hold down the left <b>ALT</b> key on your keyboard and using the number pad on the right of your keyboard type in the corresponding ASCII value.For instance, typing <b>ALT+66</b> will yield <b>B</b>.<br />
For numbers above 127 use "0 + the number". For instance to find the character which corresponds to KeyAscii value 134 you would type <b>ALT+0134</b> which yields <b>†</b>.<br />
<br />
<b><span style="color: #38761d;">Note:</span></b><br />
KeyAscii values 0 to 31 are non-printable and values 128-255 are considered "Extended". These "extended" codes may vary in appearance from computer to computer, font to font<b> </b>and may not be displayed, so please use with caution.
<br />
<table border="0" cellpadding="0" cellspacing="0" style="width: auto;"><colgroup><col style="mso-width-alt: 4022; mso-width-source: userset; width: 83pt;" width="110"></col>
 <col style="mso-width-alt: 8850; mso-width-source: userset; width: 182pt;" width="242"></col>
 <col style="mso-width-alt: 3620; mso-width-source: userset; width: 74pt;" width="99"></col>
 <col style="mso-width-alt: 4425; mso-width-source: userset; width: 91pt;" width="121"></col>
 </colgroup><tbody>
<tr height="15" style="height: 10pt; mso-height-source: userset;">
  <td class="xl72" height="15" style="align: center; background: #e5e5e5; font-weight: bold; height: 10pt; width: 83pt;" width="110">ASCII</td>
  <td class="xl73" style="align: center; background: #e5e5e5; font-weight: bold; width: 182pt;" width="242">CHAR</td>
  <td class="xl74" style="align: center; background: #e5e5e5; font-weight: bold; width: 74pt;" width="99">ASCII</td>
  <td class="xl73" style="align: center; background: #e5e5e5; font-weight: bold; width: 91pt;" width="121">CHAR</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">0</td>
  <td class="xl68" style="border-top: none;">NUL (null) / Ctrl+Shift+@</td>
  <td class="xl66" style="border-top: none;">128</td>
  <td class="xl67" style="border-top: none;">€</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">1</td>
  <td class="xl68" style="border-top: none;">SOH (start of heading) / ☺ / Ctrl+A</td>
  <td class="xl66" style="border-top: none;">129</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">2</td>
  <td class="xl68" style="border-top: none;">STX (start of text) / ☻ / Ctrl+B</td>
  <td class="xl66" style="border-top: none;">130</td>
  <td class="xl67" style="border-top: none;">‚</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">3</td>
  <td class="xl68" style="border-top: none;">ETX (end of text) / ♥ / Ctrl+C</td>
  <td class="xl66" style="border-top: none;">131</td>
  <td class="xl67" style="border-top: none;">ƒ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">4</td>
  <td class="xl68" style="border-top: none;">EOT (end of transmission) / ♦ / Ctrl+D</td>
  <td class="xl66" style="border-top: none;">132</td>
  <td class="xl67" style="border-top: none;">„</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">5</td>
  <td class="xl68" style="border-top: none;">ENQ (enquiry) / ♣ / Ctrl+E</td>
  <td class="xl66" style="border-top: none;">133</td>
  <td class="xl67" style="border-top: none;">…</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">6</td>
  <td class="xl68" style="border-top: none;">ACK (acknowledge) / ♠ / Ctrl+F</td>
  <td class="xl66" style="border-top: none;">134</td>
  <td class="xl67" style="border-top: none;">†</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">7</td>
  <td class="xl68" style="border-top: none;">BEL (bell) / • / Ctrl+G</td>
  <td class="xl66" style="border-top: none;">135</td>
  <td class="xl67" style="border-top: none;">‡</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">8</td>
  <td class="xl68" style="border-top: none;">BS (backspace) / ◘ / Ctrl+H</td>
  <td class="xl66" style="border-top: none;">136</td>
  <td class="xl67" style="border-top: none;">ˆ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">9</td>
  <td class="xl68" style="border-top: none;">TAB (horizonal tab) / ○ / Ctrl+I</td>
  <td class="xl66" style="border-top: none;">137</td>
  <td class="xl67" style="border-top: none;">‰</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">10</td>
  <td class="xl68" style="border-top: none;">LF (NL line feed, new line) / ◙ /
  Ctrl+J</td>
  <td class="xl66" style="border-top: none;">138</td>
  <td class="xl67" style="border-top: none;">Š</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">11</td>
  <td class="xl68" style="border-top: none;">VT (vertical tab) / ♂ / Ctrl+K</td>
  <td class="xl66" style="border-top: none;">139</td>
  <td class="xl67" style="border-top: none;">‹</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">12</td>
  <td class="xl68" style="border-top: none;">FF (NP form feed, new page) / ♀ /
  Ctrl+L</td>
  <td class="xl66" style="border-top: none;">140</td>
  <td class="xl67" style="border-top: none;">Œ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">13</td>
  <td class="xl68" style="border-top: none;">CR (carriage return) / ♪ / Ctrl+M</td>
  <td class="xl66" style="border-top: none;">141</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">14</td>
  <td class="xl68" style="border-top: none;">SO (shift out) / ♫ / Ctrl+N</td>
  <td class="xl66" style="border-top: none;">142</td>
  <td class="xl67" style="border-top: none;">Ž</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">15</td>
  <td class="xl68" style="border-top: none;">SI (shift in) / ☼ / Ctrl+O</td>
  <td class="xl66" style="border-top: none;">143</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">16</td>
  <td class="xl68" style="border-top: none;">DLE (data line escape) / ► / Ctrl+P</td>
  <td class="xl66" style="border-top: none;">144</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">17</td>
  <td class="xl68" style="border-top: none;">DC1 (device control 1) / ◄ / Ctrl+Q</td>
  <td class="xl66" style="border-top: none;">145</td>
  <td class="xl67" style="border-top: none;">‘</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">18</td>
  <td class="xl68" style="border-top: none;">DC2 (device control 2) / ↕ / Ctrl+R</td>
  <td class="xl66" style="border-top: none;">146</td>
  <td class="xl67" style="border-top: none;">’</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">19</td>
  <td class="xl68" style="border-top: none;">DC3 (device control 3) / ‼ / Ctrl+S</td>
  <td class="xl66" style="border-top: none;">147</td>
  <td class="xl67" style="border-top: none;">“</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">20</td>
  <td class="xl68" style="border-top: none;">DC4 (device control 4) / ¶ / Ctrl+T</td>
  <td class="xl66" style="border-top: none;">148</td>
  <td class="xl67" style="border-top: none;">”</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">21</td>
  <td class="xl68" style="border-top: none;">NAK (negative acknowledge) / § /
  Ctrl+U</td>
  <td class="xl66" style="border-top: none;">149</td>
  <td class="xl67" style="border-top: none;">•</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">22</td>
  <td class="xl68" style="border-top: none;">SYN (synchronous idle) / ▬ / Ctrl+V</td>
  <td class="xl66" style="border-top: none;">150</td>
  <td class="xl67" style="border-top: none;">–</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">23</td>
  <td class="xl68" style="border-top: none;">ETB (end of trans. block) / ↨ / Ctrl+W</td>
  <td class="xl66" style="border-top: none;">151</td>
  <td class="xl67" style="border-top: none;">—</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">24</td>
  <td class="xl68" style="border-top: none;">CAN (cancel) / ↑ / Ctrl+X</td>
  <td class="xl66" style="border-top: none;">152</td>
  <td class="xl67" style="border-top: none;">˜</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">25</td>
  <td class="xl68" style="border-top: none;">EM (end of medium) / ↓ / Ctrl+Y</td>
  <td class="xl66" style="border-top: none;">153</td>
  <td class="xl67" style="border-top: none;">™</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">26</td>
  <td class="xl68" style="border-top: none;">SUB (substitute) / → / Ctrl+Z</td>
  <td class="xl66" style="border-top: none;">154</td>
  <td class="xl67" style="border-top: none;">š</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">27</td>
  <td class="xl68" style="border-top: none;">ESC (escape) / ← / Ctrl+[</td>
  <td class="xl66" style="border-top: none;">155</td>
  <td class="xl67" style="border-top: none;">›</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">28</td>
  <td class="xl68" style="border-top: none;">FS (file separator) / ∟ / Ctrl+\</td>
  <td class="xl66" style="border-top: none;">156</td>
  <td class="xl67" style="border-top: none;">œ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">29</td>
  <td class="xl68" style="border-top: none;">GS (group separator) / ↔ / Ctrl+]</td>
  <td class="xl66" style="border-top: none;">157</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">30</td>
  <td class="xl68" style="border-top: none;">RS (record separator) / ▲ /
  Ctrl+Shift+^</td>
  <td class="xl66" style="border-top: none;">158</td>
  <td class="xl67" style="border-top: none;">ž</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">31</td>
  <td class="xl68" style="border-top: none;">US (unit separator) / ▼ / Ctrl+Shift+_</td>
  <td class="xl66" style="border-top: none;">159</td>
  <td class="xl67" style="border-top: none;">Ÿ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">32</td>
  <td class="xl68" style="border-top: none;">Space</td>
  <td class="xl66" style="border-top: none;">160</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">33</td>
  <td class="xl68" style="border-top: none;">!</td>
  <td class="xl66" style="border-top: none;">161</td>
  <td class="xl67" style="border-top: none;">¡</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">34</td>
  <td class="xl69" style="border-top: none; width: 182pt;" width="242">"</td>
  <td class="xl66" style="border-top: none;">162</td>
  <td class="xl67" style="border-top: none;">¢</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">35</td>
  <td class="xl68" style="border-top: none;">#</td>
  <td class="xl66" style="border-top: none;">163</td>
  <td class="xl67" style="border-top: none;">£</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">36</td>
  <td class="xl68" style="border-top: none;">$</td>
  <td class="xl66" style="border-top: none;">164</td>
  <td class="xl67" style="border-top: none;">¤</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">37</td>
  <td class="xl68" style="border-top: none;">%</td>
  <td class="xl66" style="border-top: none;">165</td>
  <td class="xl67" style="border-top: none;">¥</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">38</td>
  <td class="xl68" style="border-top: none;">&</td>
  <td class="xl66" style="border-top: none;">166</td>
  <td class="xl67" style="border-top: none;">¦</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">39</td>
  <td class="xl68" style="border-top: none;">'</td>
  <td class="xl66" style="border-top: none;">167</td>
  <td class="xl67" style="border-top: none;">§</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">40</td>
  <td class="xl68" style="border-top: none;">(</td>
  <td class="xl66" style="border-top: none;">168</td>
  <td class="xl67" style="border-top: none;">¨</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">41</td>
  <td class="xl68" style="border-top: none;">)</td>
  <td class="xl66" style="border-top: none;">169</td>
  <td class="xl67" style="border-top: none;">©</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">42</td>
  <td class="xl68" style="border-top: none;">*</td>
  <td class="xl66" style="border-top: none;">170</td>
  <td class="xl67" style="border-top: none;">ª</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">43</td>
  <td class="xl68" style="border-top: none;">+</td>
  <td class="xl66" style="border-top: none;">171</td>
  <td class="xl67" style="border-top: none;">«</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">44</td>
  <td class="xl68" style="border-top: none;">,</td>
  <td class="xl66" style="border-top: none;">172</td>
  <td class="xl67" style="border-top: none;">¬</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">45</td>
  <td class="xl68" style="border-top: none;">-</td>
  <td class="xl66" style="border-top: none;">173</td>
  <td class="xl67" style="border-top: none;"></td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">46</td>
  <td class="xl68" style="border-top: none;">.</td>
  <td class="xl66" style="border-top: none;">174</td>
  <td class="xl67" style="border-top: none;">®</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">47</td>
  <td class="xl68" style="border-top: none;">/</td>
  <td class="xl66" style="border-top: none;">175</td>
  <td class="xl67" style="border-top: none;">¯</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">48</td>
  <td class="xl68" style="border-top: none;">0</td>
  <td class="xl66" style="border-top: none;">176</td>
  <td class="xl67" style="border-top: none;">°</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">49</td>
  <td class="xl68" style="border-top: none;">1</td>
  <td class="xl66" style="border-top: none;">177</td>
  <td class="xl67" style="border-top: none;">±</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">50</td>
  <td class="xl68" style="border-top: none;">2</td>
  <td class="xl66" style="border-top: none;">178</td>
  <td class="xl67" style="border-top: none;">²</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">51</td>
  <td class="xl68" style="border-top: none;">3</td>
  <td class="xl66" style="border-top: none;">179</td>
  <td class="xl67" style="border-top: none;">³</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">52</td>
  <td class="xl68" style="border-top: none;">4</td>
  <td class="xl66" style="border-top: none;">180</td>
  <td class="xl67" style="border-top: none;">´</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">53</td>
  <td class="xl68" style="border-top: none;">5</td>
  <td class="xl66" style="border-top: none;">181</td>
  <td class="xl67" style="border-top: none;">µ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">54</td>
  <td class="xl68" style="border-top: none;">6</td>
  <td class="xl66" style="border-top: none;">182</td>
  <td class="xl67" style="border-top: none;">¶</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">55</td>
  <td class="xl68" style="border-top: none;">7</td>
  <td class="xl66" style="border-top: none;">183</td>
  <td class="xl67" style="border-top: none;">·</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">56</td>
  <td class="xl68" style="border-top: none;">8</td>
  <td class="xl66" style="border-top: none;">184</td>
  <td class="xl67" style="border-top: none;">¸</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">57</td>
  <td class="xl68" style="border-top: none;">9</td>
  <td class="xl66" style="border-top: none;">185</td>
  <td class="xl67" style="border-top: none;">¹</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">58</td>
  <td class="xl68" style="border-top: none;">:</td>
  <td class="xl66" style="border-top: none;">186</td>
  <td class="xl67" style="border-top: none;">º</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">59</td>
  <td class="xl68" style="border-top: none;">;</td>
  <td class="xl66" style="border-top: none;">187</td>
  <td class="xl67" style="border-top: none;">»</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">60</td>
  <td class="xl68" style="border-top: none;"><</td>
  <td class="xl66" style="border-top: none;">188</td>
  <td class="xl67" style="border-top: none;">¼</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">61</td>
  <td class="xl68" style="border-top: none;">=</td>
  <td class="xl66" style="border-top: none;">189</td>
  <td class="xl67" style="border-top: none;">½</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">62</td>
  <td class="xl68" style="border-top: none;">></td>
  <td class="xl66" style="border-top: none;">190</td>
  <td class="xl67" style="border-top: none;">¾</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">63</td>
  <td class="xl68" style="border-top: none;">?</td>
  <td class="xl66" style="border-top: none;">191</td>
  <td class="xl67" style="border-top: none;">¿</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">64</td>
  <td class="xl68" style="border-top: none;">@</td>
  <td class="xl66" style="border-top: none;">192</td>
  <td class="xl67" style="border-top: none;">À</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">65</td>
  <td class="xl68" style="border-top: none;">A</td>
  <td class="xl66" style="border-top: none;">193</td>
  <td class="xl67" style="border-top: none;">Á</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">66</td>
  <td class="xl68" style="border-top: none;">B</td>
  <td class="xl66" style="border-top: none;">194</td>
  <td class="xl67" style="border-top: none;">Â</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">67</td>
  <td class="xl68" style="border-top: none;">C</td>
  <td class="xl66" style="border-top: none;">195</td>
  <td class="xl67" style="border-top: none;">Ã</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">68</td>
  <td class="xl68" style="border-top: none;">D</td>
  <td class="xl66" style="border-top: none;">196</td>
  <td class="xl67" style="border-top: none;">Ä</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">69</td>
  <td class="xl68" style="border-top: none;">E</td>
  <td class="xl66" style="border-top: none;">197</td>
  <td class="xl67" style="border-top: none;">Å</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">70</td>
  <td class="xl68" style="border-top: none;">F</td>
  <td class="xl66" style="border-top: none;">198</td>
  <td class="xl67" style="border-top: none;">Æ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">71</td>
  <td class="xl68" style="border-top: none;">G</td>
  <td class="xl66" style="border-top: none;">199</td>
  <td class="xl67" style="border-top: none;">Ç</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">72</td>
  <td class="xl68" style="border-top: none;">H</td>
  <td class="xl66" style="border-top: none;">200</td>
  <td class="xl67" style="border-top: none;">È</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">73</td>
  <td class="xl68" style="border-top: none;">I</td>
  <td class="xl66" style="border-top: none;">201</td>
  <td class="xl67" style="border-top: none;">É</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">74</td>
  <td class="xl68" style="border-top: none;">J</td>
  <td class="xl66" style="border-top: none;">202</td>
  <td class="xl67" style="border-top: none;">Ê</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">75</td>
  <td class="xl68" style="border-top: none;">K</td>
  <td class="xl66" style="border-top: none;">203</td>
  <td class="xl67" style="border-top: none;">Ë</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">76</td>
  <td class="xl68" style="border-top: none;">L</td>
  <td class="xl66" style="border-top: none;">204</td>
  <td class="xl67" style="border-top: none;">Ì</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">77</td>
  <td class="xl68" style="border-top: none;">M</td>
  <td class="xl66" style="border-top: none;">205</td>
  <td class="xl67" style="border-top: none;">Í</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">78</td>
  <td class="xl68" style="border-top: none;">N</td>
  <td class="xl66" style="border-top: none;">206</td>
  <td class="xl67" style="border-top: none;">Î</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">79</td>
  <td class="xl68" style="border-top: none;">O</td>
  <td class="xl66" style="border-top: none;">207</td>
  <td class="xl67" style="border-top: none;">Ï</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">80</td>
  <td class="xl68" style="border-top: none;">P</td>
  <td class="xl66" style="border-top: none;">208</td>
  <td class="xl67" style="border-top: none;">Ð</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">81</td>
  <td class="xl68" style="border-top: none;">Q</td>
  <td class="xl66" style="border-top: none;">209</td>
  <td class="xl67" style="border-top: none;">Ñ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">82</td>
  <td class="xl68" style="border-top: none;">R</td>
  <td class="xl66" style="border-top: none;">210</td>
  <td class="xl67" style="border-top: none;">Ò</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">83</td>
  <td class="xl68" style="border-top: none;">S</td>
  <td class="xl66" style="border-top: none;">211</td>
  <td class="xl67" style="border-top: none;">Ó</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">84</td>
  <td class="xl68" style="border-top: none;">T</td>
  <td class="xl66" style="border-top: none;">212</td>
  <td class="xl67" style="border-top: none;">Ô</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">85</td>
  <td class="xl68" style="border-top: none;">U</td>
  <td class="xl66" style="border-top: none;">213</td>
  <td class="xl67" style="border-top: none;">Õ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">86</td>
  <td class="xl68" style="border-top: none;">V</td>
  <td class="xl66" style="border-top: none;">214</td>
  <td class="xl67" style="border-top: none;">Ö</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">87</td>
  <td class="xl68" style="border-top: none;">W</td>
  <td class="xl66" style="border-top: none;">215</td>
  <td class="xl67" style="border-top: none;">×</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">88</td>
  <td class="xl68" style="border-top: none;">X</td>
  <td class="xl66" style="border-top: none;">216</td>
  <td class="xl67" style="border-top: none;">Ø</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">89</td>
  <td class="xl68" style="border-top: none;">Y</td>
  <td class="xl66" style="border-top: none;">217</td>
  <td class="xl67" style="border-top: none;">Ù</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">90</td>
  <td class="xl68" style="border-top: none;">Z</td>
  <td class="xl66" style="border-top: none;">218</td>
  <td class="xl67" style="border-top: none;">Ú</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">91</td>
  <td class="xl68" style="border-top: none;">[</td>
  <td class="xl66" style="border-top: none;">219</td>
  <td class="xl67" style="border-top: none;">Û</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">92</td>
  <td class="xl68" style="border-top: none;">\</td>
  <td class="xl66" style="border-top: none;">220</td>
  <td class="xl67" style="border-top: none;">Ü</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">93</td>
  <td class="xl68" style="border-top: none;">]</td>
  <td class="xl66" style="border-top: none;">221</td>
  <td class="xl67" style="border-top: none;">Ý</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">94</td>
  <td class="xl68" style="border-top: none;">^</td>
  <td class="xl66" style="border-top: none;">222</td>
  <td class="xl67" style="border-top: none;">Þ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">95</td>
  <td class="xl68" style="border-top: none;">_</td>
  <td class="xl66" style="border-top: none;">223</td>
  <td class="xl67" style="border-top: none;">ß</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">96</td>
  <td class="xl68" style="border-top: none;">`</td>
  <td class="xl66" style="border-top: none;">225</td>
  <td class="xl67" style="border-top: none;">á</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">97</td>
  <td class="xl68" style="border-top: none;">a</td>
  <td class="xl66" style="border-top: none;">226</td>
  <td class="xl67" style="border-top: none;">â</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">98</td>
  <td class="xl68" style="border-top: none;">b</td>
  <td class="xl66" style="border-top: none;">227</td>
  <td class="xl67" style="border-top: none;">ã</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">99</td>
  <td class="xl68" style="border-top: none;">c</td>
  <td class="xl66" style="border-top: none;">228</td>
  <td class="xl67" style="border-top: none;">ä</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">100</td>
  <td class="xl68" style="border-top: none;">d</td>
  <td class="xl66" style="border-top: none;">229</td>
  <td class="xl67" style="border-top: none;">å</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">101</td>
  <td class="xl68" style="border-top: none;">e</td>
  <td class="xl66" style="border-top: none;">230</td>
  <td class="xl67" style="border-top: none;">æ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">102</td>
  <td class="xl68" style="border-top: none;">f</td>
  <td class="xl66" style="border-top: none;">231</td>
  <td class="xl67" style="border-top: none;">ç</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">103</td>
  <td class="xl68" style="border-top: none;">g</td>
  <td class="xl66" style="border-top: none;">232</td>
  <td class="xl67" style="border-top: none;">è</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">104</td>
  <td class="xl68" style="border-top: none;">h</td>
  <td class="xl66" style="border-top: none;">233</td>
  <td class="xl67" style="border-top: none;">é</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">105</td>
  <td class="xl68" style="border-top: none;">i</td>
  <td class="xl66" style="border-top: none;">234</td>
  <td class="xl67" style="border-top: none;">ê</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">106</td>
  <td class="xl68" style="border-top: none;">j</td>
  <td class="xl66" style="border-top: none;">235</td>
  <td class="xl67" style="border-top: none;">ë</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">107</td>
  <td class="xl68" style="border-top: none;">k</td>
  <td class="xl66" style="border-top: none;">236</td>
  <td class="xl67" style="border-top: none;">ì</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">108</td>
  <td class="xl68" style="border-top: none;">l</td>
  <td class="xl66" style="border-top: none;">237</td>
  <td class="xl67" style="border-top: none;">í</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">109</td>
  <td class="xl68" style="border-top: none;">m</td>
  <td class="xl66" style="border-top: none;">238</td>
  <td class="xl67" style="border-top: none;">î</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">110</td>
  <td class="xl68" style="border-top: none;">n</td>
  <td class="xl66" style="border-top: none;">239</td>
  <td class="xl67" style="border-top: none;">ï</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">111</td>
  <td class="xl68" style="border-top: none;">o</td>
  <td class="xl66" style="border-top: none;">240</td>
  <td class="xl67" style="border-top: none;">ð</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">112</td>
  <td class="xl68" style="border-top: none;">p</td>
  <td class="xl66" style="border-top: none;">241</td>
  <td class="xl67" style="border-top: none;">ñ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">113</td>
  <td class="xl68" style="border-top: none;">q</td>
  <td class="xl66" style="border-top: none;">242</td>
  <td class="xl67" style="border-top: none;">ò</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">114</td>
  <td class="xl68" style="border-top: none;">r</td>
  <td class="xl66" style="border-top: none;">243</td>
  <td class="xl67" style="border-top: none;">ó</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">115</td>
  <td class="xl68" style="border-top: none;">s</td>
  <td class="xl66" style="border-top: none;">244</td>
  <td class="xl67" style="border-top: none;">ô</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">116</td>
  <td class="xl68" style="border-top: none;">t</td>
  <td class="xl66" style="border-top: none;">245</td>
  <td class="xl67" style="border-top: none;">õ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">117</td>
  <td class="xl68" style="border-top: none;">u</td>
  <td class="xl66" style="border-top: none;">246</td>
  <td class="xl67" style="border-top: none;">ö</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">118</td>
  <td class="xl68" style="border-top: none;">v</td>
  <td class="xl66" style="border-top: none;">247</td>
  <td class="xl67" style="border-top: none;">÷</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">119</td>
  <td class="xl68" style="border-top: none;">w</td>
  <td class="xl66" style="border-top: none;">248</td>
  <td class="xl67" style="border-top: none;">ø</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">120</td>
  <td class="xl68" style="border-top: none;">x</td>
  <td class="xl66" style="border-top: none;">249</td>
  <td class="xl67" style="border-top: none;">ù</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">121</td>
  <td class="xl68" style="border-top: none;">y</td>
  <td class="xl66" style="border-top: none;">250</td>
  <td class="xl67" style="border-top: none;">ú</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">122</td>
  <td class="xl68" style="border-top: none;">z</td>
  <td class="xl66" style="border-top: none;">251</td>
  <td class="xl67" style="border-top: none;">û</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">123</td>
  <td class="xl68" style="border-top: none;">{</td>
  <td class="xl66" style="border-top: none;">252</td>
  <td class="xl67" style="border-top: none;">ü</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">124</td>
  <td class="xl68" style="border-top: none;">|</td>
  <td class="xl66" style="border-top: none;">253</td>
  <td class="xl67" style="border-top: none;">ý</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">125</td>
  <td class="xl68" style="border-top: none;">}</td>
  <td class="xl66" style="border-top: none;">254</td>
  <td class="xl67" style="border-top: none;">þ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">126</td>
  <td class="xl68" style="border-top: none;">~</td>
  <td class="xl66" style="border-top: none;">255</td>
  <td class="xl67" style="border-top: none;">ÿ</td>
 </tr>
<tr height="21" style="height: 15.75pt;">
  <td class="xl65" height="21" style="border-top: none; height: 15.75pt;">127</td>
  <td class="xl68" style="border-top: none;">DEL / CTRL-Backspace</td>
  <td class="xl76" style="border-top: none;"></td>
  <td class="xl77" style="border-top: none;"></td>
 </tr>
</tbody></table>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
* ASCII code 127 has the code DEL. Under MS-DOS, this code has the same effect has ASCII 8 (BS). The DEL code can be generated by the CTRL + BKSP key.<br />
<div>
<br /></div>
</div>

keyascii chart keyascii code vb6 keyascii VB KeyAscii Code and Values

Visual Basic KeyAscii Values can range from 0 to 255. Here is a chart which shows all possible KeyAscii values along with the character which they represent.To type out any of these characters without pressing the actual character you can do this.H…