How to use VBA code in Excel

– selva v pasupathy, HSBC Global Resourcing, Hyderabad
You may find various code snippets in pages of this website, or on a website, and decide to

add it to one of your workbooks. Most code can be added by doing the following:

  1. Copy the code that you want to use
  2. Select the workbook in which you want to store the code
  3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
  4. Choose Insert | Module (to insert a new code module)
  5. Now you will see the cursor flashing in the code window of a new module that you

    inserted. choose Edit | Paste from toolbar.

  6. Now, hold the alt key, and press F11 key to go back to excel main window.
  7. To run the code: Choose Tools | Macro | Macros from toolbar
  8. You will see a popup window with list of macros avialable. Choose the macro that you

    want to use and click on run.

9 Comments »

  1. […] Get FileNames with Path from User Posted in VBA Examples by selvavpasupathy on October 9th, 2008 HOW SHOULD I USE THE FOLLOWING CODE […]

  2. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  3. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  4. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  5. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  6. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  7. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  8. […] HOW SHOULD I USE THE FOLLOWING CODE […]

  9. […] HOW SHOULD I USE THE FOLLOWING CODE […]

RSS feed for comments on this post · TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: