Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating excel file, adding code to it from code, VBE window stays | Excel Programming | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |