How to create a drop down list in Excel? Also learn how to create/add data validation, change the selection in drop down or delete Validation list using the Excel Macro. It is a Drop down list complete guide for Excel users.
get Excel VBA Shell Command Output within Macro
Read the output of Excel vba shell command within macro.Issue any function to execute shell command prompt thru vba Shell & read the output in Excel Macro
Find My PC Screen Resolution in Excel using VBA & Javascript
Code to find Screen resolution of your computer. This code gets the screen width & height VBA (Windows API), C, Javascript & Command prompt functions.
Convert VBA Declare Compatible with 64 Bit Office
Coding Excel VBA 64 bit compatible for 32 bit. Also convert VBA 32 bit to 64 bit by declare PtrSafe 64 bit of Win API functions of VB6 & VB7 editor.
Open VCF File Online – Free VCF Viewers & Editors
How to open open vcf file online free, using these tools without using any special converter apps. With this method, you will be able to view the complete contact details of vCard file in Excel & Online browsers.
VBA to Create Email List using Excel – Distribution List
Use this VBA code or Excel app to create Email List using Excel. Created distribution list can be used to email to multiple recipients for Marketing purpose
Excel VBA Check – IF String Contains – Only Letters
VBA check if string contains only Letters function in this page can be used in your vba project module & referred in any place to check & trim your string.
Excel Import Data – From another Workbook – Query External Source
Learn how to make Excel import data from another workbook using Microsoft query method in simple steps. Also learn external reference data import techniques
Convert a Formatted Cell in Excel into HTML Tag using VBA
Convert a formatted cell in Excel to HTML tag using VBA code. A Cell can have single or multiple font formats. This code converts each type to HTML Tag.
Excel VBA Get Stock Price – Google Finance – Best Live Stock Ticker
Using Excel vba get stock price from Google finance. Build youself a best Live stock ticker using this VBA code for any share market data