Pinoy Tutorials, Tips and Tricks

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

<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…