#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default VBA code

Hello,

I am learning VBA code. Have a book, not too helpful.
A few days ago I saw a problem and a set of codes to solve the programmer's
problem.

What is the meaning of:

Selection.Insert Shift:=xlDown

Are there any resources that list codes and meanings?

Thanks!

Gabor

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA code

The VBA help file is very useful in listing the definitions of terms and
providing examples of their usage.

To access the VBA help file, pres ALT + F11 which will display the Visual
Basic Editor screen. Click on help from bht VBE menu bar. In the small
window pane to the right of the screen you will see a search box where you
can enter key words to be seached and then select topics from those
displayed after pressing enter. Also, near the top of that pane are left
arrow and right arrow icons. By clicking these you can find a menu of
electronic manuals for VBA language relative to the application that you are
in.

You can also Google for VBA tutorials on the web.



"helene and gabor" wrote in message
...
Hello,

I am learning VBA code. Have a book, not too helpful.
A few days ago I saw a problem and a set of codes to solve the
programmer's problem.

What is the meaning of:

Selection.Insert Shift:=xlDown

Are there any resources that list codes and meanings?

Thanks!

Gabor



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA code

Also, this web site may be helpful:

http://www.excel-vba.com/index.htm


"helene and gabor" wrote in message
...
Hello,

I am learning VBA code. Have a book, not too helpful.
A few days ago I saw a problem and a set of codes to solve the
programmer's problem.

What is the meaning of:

Selection.Insert Shift:=xlDown

Are there any resources that list codes and meanings?

Thanks!

Gabor



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
Creating excel file, adding code to it from code, VBE window stays BlueWolverine Excel Programming 0 November 5th 09 07:55 PM
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? [email protected] Excel Programming 4 May 29th 09 10:13 PM
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does ker_01 Excel Programming 6 October 3rd 08 09:45 PM
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. Corey Excel Programming 3 December 11th 06 05:14 AM
Excel code convert to Access code - Concat & eliminate duplicates italia Excel Programming 1 September 12th 06 12:14 AM


All times are GMT +1. The time now is 10:34 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"