Interesting Excel Solutions including VBA Help for Newbies And Advanced Users

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
Home
     Webhosting by Godaddy     MS Excel Books





Many Microsoft Excel users who begin to learn Excel VBA have often asked these two questions like Michael, one of our website visitors:
I have just started learning Microsoft Excel VBA. Can you please help me with two problems?
1. What statement must be used to 'end' a macro?
2. What happens if you insert an apostrophe at the beginning of a macro statement? Thanks.
Michael
P. S.: I'm using MS Excel 2003.

The macro code:
Sub finalprice()
'Range("D2").Value = Range("B2").Value + Range("C2").Value * Range("B2").Value
MsgBox ("Please remove the apostrophe to perform the calculation")
End Sub

We can often use the apostrophe to try out different versions of our macro code. Once we are satisfied with our final working we can delete the commented code or keep it for future reference.



More Tips (Solutions):
How do I view and edit Microsoft Excel files on an iPad?
Inventory Soluton
How to rename and color worksheet tabs
Copy Worksheet Quickly
Criteria Range
Animations in Microsoft Excel
Create two charts at once
How to avoid errors while working in Excel
How to benefit from Microsoft Excel Templates
How to use Microsoft Excel 2007 with Word 2007 - create mail merge labels
Landscape Oriented Worksheet Template
How to-make a worksheet fit a printed page
How to make your charts more impressive
Perpetual Calendar from 1900 to 9999
How to create your own custom add-in
How to clear  conditional formattng  in Excel worksheets
How to speed up data entry of decimal numbers
How to change the color of the gridlines of an Excel worksheet or hide them
How to use Autosum in Multiple Worksheet Cells Quickly
How to have your free personal assistant in Mcrosoft Excel who reads out the data to you
How to use the status bar in Microsoft Excel to do a quick data analysis
How to calculate equal monthly payments or instalments using a mathematical equation
Data Forms to Enter and Edit Data
View 2 worksheets in same workbook side by side
Accessing a specific worksheet in large workbooks with multiple worksheets
Referencing a cell in another worksheet
How to perform a what-if analysis using a scrollbar form control
An interesting payroll solution
Future Value Solution in Microsoft Excel
Another Interesting Conditional Formatting Solution
DSUM and Array Formulas for addition solutions
IF Function Question
How to use command buttons on a splash screen in MS-Excel
Copy Paste Data from one Excel Worksheet to Another
How to separate comma separated values (csv) in a worksheet cell in Microsoft Excel into rows or columns
Another Interesting Solver solution in Microsoft Excel
Find duplicates in two different Excel worksheets using a macro
How to count data based on multiple criteria - countifs function
How to convert 6/5/2011 into Sunday, 6/5/2011
User Form to perform calculations
An interesting solution using conditional formatting in Microsoft Excel 2007
Show/Hide Controls on a User-Form using a Checkbox
Populate Listbox and Textboxes with Excel data using VBA and Vlookup
Protecting Specific Worksheets in an Excel Workbook using VBA
How to calculate the difference in hours between two date-time values
How do I match data from 2 worksheets and highlight the differences using MS-Excel VBA?
How to focus on a specific control (TextBox1) on a user-form in MS-Excel
Interesting sumproduct solution
COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS
VLOOKUP SOLUTION USING LIST IN MS EXCEL
How to generate random numbers in MS Excel
Lottery game in Microsoft Excel
Nested If Function to Determine Project Complexity
Power Billing Solution in Microsoft Excel
Solver Excel - An easy to understand example
Another Interest Calculation Solution
Interesting Microsoft Excel Formula Based on Date and Row Functions
How to subtract dates in Microsoft Excel
Automating rounding of decimal numbers in MS-Excel
How to Calculate Profit Loss of security transactions in MS Excel
How to print comments in Microsoft Excel
How to Display Results in a Specific Way in Excel
How to Filter or Hide Rows & Display Excel Data in Excel Using A Macro
Automate Chart Creation Using Excel Macros (VBA)
Add Text To Displayed Excel Numerical Value
How to develop an advanced function or formula in MS-Excel
Apply Autofilter Across Multiple Excel Worksheets
Inventory Solution in Microsoft Excel
How to open a password protected Excel worksheet whose password has been lost
Hyperlinks and VBA Code to Navigate worksheets in Large Workbooks
Count Total Between Two Dates Using COUNTIFS Function
Dice Game in MS-Excel
Where is my autofill handle?
Payment Calculations based on Timestamps
How to convert an Excel File into a Text File
How to consolidate data from multiple workbooks or files
How to display the value of a number in words in Excel
Copy Paste Data from one Excel Worksheet to another using an Inputbox
How to Calculate Amount Due on Delayed Invoice Payments
Interesting Use of Combo-Box Form Control
How to Use Excel - MROUND() Function
How to print formulas in Excel
Excel VBA Example
Custom Formulas - Excel Financial Calculator
Interesting use of Advanced Filter in MS Excel
Find Duration in Hours between two Dates using VBA
Display or Hide Controls on UserForm Using Option Buttons
Tables in MS Excel
Inventory Management - User-Forms
Inventory Management - SUMIF function
Copy - Paste Special - Paste Link - MS Excel - MS Word
Generating permanent random numbers using an Excel macro
Practical Solution Using SUMPRODUCT
Adding Special Numbers in MS Excel
Display Message in One TextBox Based on Entry in Another TextBox
Find Missing Data Using COUNTIF Nested in IF Function
Save Excel Files Automatically Using Cell Data
Limit user input in a text box or an Excel Worksheet Cell
How to copy data from one Excel worksheet to another and print
Class Module, Objects and Collections in Excel VBA
How to sort Excel data automatically
Automatic Report Generation in MS Excel
Financial Planning Using MS Excel
Home Loan Refinance Calculations Using MS Excel
Help Jenny Decide - NPV in MS Excel
NPV Calculations in MS Excel - Which Project Should GE Undertake?
Cash Flows and Project Viability in MS Excel
Bonds Pricing in MS Excel
Valuation of Bonds in MS Excel
Update Appointments Data Automatically in MS Excel
Graphs in MS Excel to avoid heavy calculations
Home Loan Refinance Calculations in MS Excel - a new example
Create Grade Sheet in MS Excel
Adding only positive values in a range of postive and negative values
Project end warning with and without VBA
Design User-Form with Listbox, Labels, TextBoxes, OptionButtons and Command Button
Compare Dates & password Protect Worksheet Using Excel VBA
Clock  Userform & more controls
Scrape or Pull Data Automatically from Websites into Excel
Complete Automation of Getting Web Page Data into Excel Worksheet Using VBA
How to use automation to send MS Outlook mail using Excel VBA
How to use multiple listboxes on a user-form in MS Excel
Transfer data from one Excel worksheet to another automatically
Tables as databases in MS Excel
Convert PDF to Excel
Merge data of excel cells without losing data using VBA
Count dates in MS Excel
Convert shortcuts to full form using Excel VBA
For Loop - Excel VBA Training
Automatic Date & Time entry using Excel VBA
How to open & Close Userform Automatically Using excel VBA
How to auto-run a VBA project
Highlight Excel cells while entering data
How to create a checkout list automatically using Excel VBA
Calculating Time Differences in MS Excel
How to increase or decrease the value of a worksheet cell automatically
Using a ListBox on an Excel UserForm
Autofit Data Automatically in Columns in MS Excel
How to Extract or Pull Specific Words from a Database or Collection
How to Convert MS Excel Formula to VBA Code
Copy Paste Excel Chart into PowerPoint Using Paste Special
AutoFill Data Using Excel VBA
How to Add Custom List Using Excel VBA
Protect Excel Worksheet Using VBA
Convert Numbers to dates Using Excel VBA
How to Display Tip of The Day in Excel Using VBA
How to create timer-counter using Excel VBA
How to Confirm Data Entry Values in an Excel Worksheet Using VBA
How to Transfer Data from One Excel Workbook to Another Automatically
How to Create Notifications or Reminders Automatically in Excel
How to Display Date & Time Automatically in Excel Using VBA
How to Allow ONLY Numerical Values in Excel user-form Text-Box Using VBA
How to Print Specific Worksheet from Multiple Worksheets in Workbook Using VBA
Compare two Excel Worksheets Cell by Cell Using VBA
How to Fill Listbox on Excel User-Form with Unique Values from Worksheet
Display all worksheets of a workbook in listbox and print specific worksheet
Enter Value in One Worksheet and Generate Many Values in Another Sheet
Delete Specific Data from an Excel Worksheet Using VBA
Coding Command Button to Display Message after Performing Calculations
How to Consolidate Data from Multiple Excel Workbooks Using VBA
Prevent User from Closing Workbook Using Excel VBA
How to Login Automatically into Website Using Excel VBA
How to Add Multiple Worksheets to Workbook and Name Them Automatically
How to share files on the net
Automatically Select Entire Worksheet Row on Click inside any cell Using Excel VBA
Using Symbols Like 'Tick' and 'Cross' in Drop-Down List in Excel Worksheet
How to Hide Excel VBA Code Using Password
Create Order Timer in MS Excel Using VBA
Developing an Interesting Formula Using Multiple Functions
Automated Goods & Service Tax (GST) Calculations Using Excel VBA
Find Data in Specific Cells in Mutiple Excel Worksheets using VBA
Error Handling in MS Excel Visual Basic for Applications VBA
Assign Keyboard Shortcut to Macros Using Excel VBA
Add City Code to Mobile Phone Numbers Automatically
How to Compare and Merge Multiple Workbooks to Create a Master File
Troubleshooting Excel VBA Queries
Debug Excel VBA Code Line by Line for Errors
Calculate Shipment Cost Userform Excel VBA
Customer Query Interface using Userform
Transfer Data from Multiple Workbooks into Master Workbook Automatically
Move Excel Workbooks from one Folder to another Using VBA
Scraping Web Page Data Automatically with Excel VBA
Troubleshoot Copy Paste Data using Excel VBA
How to Copy Worksheet from Another Workbook, Rename it and check whether Other Workbook was Already Open
How to Run VBA Code or Macro on a Protected Sheet
Generate Test Paper from Question Bank Using Excel VBA
Extract Specific Link From Web Pages Using Excel VBA
Copy Data From One Workbook to Another to a Specific Worksheet
3 Excel VBA Training Questions on YouTube
Troubleshhoot Excel VBA Code Based on Queries
Attendance Automation Using Excel VBA
Copy Paste Multiple Rows of Data from One WorkBook to Another Using Excel VBA
Pop-up Calendar Add-In Using Excel VBA
Advanced UserForm
Automate Data Extraction Without Opening Destination Workbook Excel VBA
Transfer Specific Data from one Worksheet to another for Reports
Scraping Webpage Tables Data Using VBA
Copy Data to Another Excel WorkBook Based on Criteria Using VBA
Populate ComboBox on Excel UserForm with Unique Items Using VBA
Sort Excel Worksheet Data and ComboBox Data Using VBA
Create Charts Using Excel VBA
Embed Chart in Worksheet Using Excel VBA
Create Pivot Tables Using VBA - Pivot Cache
How to manipulate Pivot Fields in Pivot Table using VBA
How to Update PivotTable When Source Data in Excel Worksheet Changes
Extract Data from one Excel Worksheet to another using Advanced Filter with VBA
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010

Home