Concept of Macro
Main aap ko aik example kay thru macro ka concept batanay key koshish karta hou ….. Iss kay liye hum Excel kay VB Editor main Aik marco likhtay hain …..
Aap below steps excel ko run kay kay karain ….
Open the VBE (Alt+F11)
Click Insert | Module
Copy the entire code from "Function to End Function" from my post
Code:
Function myadd(x As Integer, y As Integer)
myadd = x + y
End FunctionPaste it into the code pane (right-hand pane)
Press Alt+Q to close the VBE
Aab aap excel main kissi bhi cell main myadd=(A2,A5) (ya koi bhoi do cell , kay sath lihain gay to yah A2 aur A5 main mojoud cells ko aapus main add kar day ga.
Programming terminology main yah function kahlata hay aur Excel main hum issay macro kahtay hain.
Flash Object ko insert karnay kay liye do the below steps ……
1. Firstly, in Excel 2003 and below, open the control toolbox.
2. Choose "More controls", then "Shockwave Flash Object". Drag a rectangle to the size of your choice. Right-click, choose "Properties".
3. In the "Properties" dialog, scroll to the top and there should be a heading called "custom". In the box next to this, when you click it, a button with "..." should appear. Click this button. A window will appear.
4. In one of the boxes in this window you need to enter the full URL of your flash object, e.g C:\flashthing.swf
5. In the same window check Embeded Movie
6. Now In Properties Control box check the box next to "Embed Movie" as true
7. Click "OK", save the spreadsheet, close it and open it.
Your flash object will be running
Bookmarks