Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default Initiating the VBA program

Which code window did you copy/paste it into? Normally, you would put it
into a Module (Insert/Module from the VB menu bar), but this would require
the code to reference the worksheets that any ranges are on (otherwise the
active sheet would be used by default and that may not be what you want or
need). If you put it in a worksheet module, then that worksheet would have
to be active in order for the macro to have any unspecified ranges refer to
it. Assuming you have the code in the correct place, you can get to it by
pressing Alt+F8. After pressing Alt+F8, you can select the macro and run it
directly OR you can click the Options button on the dialog box and assign a
keystroke combination to run it from the dialog box that appears.

--
Rick (MVP - Excel)


"Dino" wrote in message
...
Hi, this is a very basic question: I found a VBA program here that I think
might help solve my problem, but once I copy and paste the code into the
code
window, how do I make the program run? When I create a macro, I give the
macro a keystroke combination to run, but when I create/copy a VBA program
I
don't know how to start the code running once I get back to the
spreadsheet.

Thanks to anyone who can help,
Dino


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Initiating the VBA program Jacob Skaria Excel Programming 0 June 11th 09 08:12 PM
Initiating the VBA program Barb Reinhardt Excel Programming 0 June 11th 09 08:09 PM
Initiating the VBA program Patrick Molloy Excel Programming 0 June 11th 09 08:05 PM
Initiating a Macro Setts Excel Worksheet Functions 2 June 28th 08 05:27 PM
initiating a macro johnT Excel Worksheet Functions 9 April 2nd 05 03:43 PM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"