working with tables

M

Marie Lavoie

Is there a site where I could find a list of the functions so I can work
with Excel?

I never programmed with VB and Excel before, but I usually find my way
out.(I programmed a bit in VB, but a long time ago and in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and if the first cell of
the row meets a condition, then insert a row after the last one entered and
paste the information in the following cells of the row on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the info into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel? Like inserting a row.
3- can i indicate a cell where I want a variable to print it's data.

Thank you

Marie
 
K

Kris

Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read about
what you want to do, the macro recorder should be able to
give you everthing that you need.

Then about the only thing that you have to worry about is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is quite
good with VBA, complete with examples of most commands.
 
M

Marie Lavoie

LOL, I was recording a macro where I insert a line to see the code, when I
decided to come see if I had an answer! ;-)
Thank you, I guess you're right, that will be the best way.

Now, I've just finished recording it, but I can't find where I can see the
code (My VB is open and it is not there as an object... normal? I'm not sure
where to look)

Marie
 
K

Ken Wright

Assuming you selected "Store macro in this workbook"

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you
need to search for
your workbook's name, and when you find it you may need to click on the + to
expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You likely just have just one of these though)

If you have named your sheets then those names will appear in the brackets above
as opposed to
what you see at the moment in my note.

Doubleclick on the Module1 bit to see the code stored within it. When done,
simply hit File / Close and return to Microsoft Excel and save the file.
 
A

Anders S

Marie,
Now, I've just finished recording it, but I can't find where I can see the
code (My VB is open and it is not there as an object... normal? I'm not sure
where to look)
Click to expand...

In the VBA editor find Module1 in the Project Browser
- or -
in Excel Tools>Macro>Macros, select your macro and click Edit

HTH
Anders Silven
 
S

steve

in xl go to tools-macro-vb editor
that will open vba
if you do not see the project - vbaproject window
go to view-project explorer
in that window you will see all xl workbooks opend
click on the plus sgin next to the one your recoreded the
macro in
if it is a - then you can already see the object folders
click on the modules +
if it is a - you can already see all the modules
double click on all the modules untill you find the one
that contains the code you recoreded

ya i dont care about spelling or grammer :)
 
Top