Go google and type in -- user manual for excel--- there are some site that cover the whole manual all 900 odd pages and some sites that deal with specific areas
some are pdf versions so you can down load the section that you want rather then the whole publication
another google search is --libra office cal-search--- which is a free excel user manual, and I found to be better than microsoft excel and it uses the same terms and formula and the whole publication is free
again you can read the publication until you come to the chapter on macro and print out the pages that you want free
worth the read if you are a microsoft person
SOURCE: Macro to be used in Excel
Instead of me teaching u. i would suggest u learn it by following the simple steps.
1. Click Tools > Macros > record
2. do some common operation like copying data, creating graphs, etc.
3. press alt+F11 to go to vb editor, to see ur macro recorded
4. study it ... u will learn easily
or
try the book 'Microsoft Excel Visual Basic Macros Examples' at http://www.add-ins.com/vbexamplestopics.htm
bye
have a nice day
SOURCE: Macro
Hi alwinkumar
You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.
Private Sub resetForm()
'formname.itemname = value
UserForm1.Label1 = "Hello World"
End Sub
For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below
numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count
SOURCE: macro in excel
Open up your Excel and hit ALT + F11. This opens up the VBA editor.
You can then right click and click New Module and write your macro in there.
Excel Workbook
.xlsx
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Excel Macro-Enabled
Workbook
.xlsm
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
Excel Template
.xltx
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Excel Macro-Enabled
Template
.xltm
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
Excel Add-In
.xlam
A supplemental
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
sheets.
69 views
Usually answered in minutes!
×