If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Visual Basic for Excel

irishgeo · 2002-02-16 00:36:06

I am a 4th year degree student in GMIT Galway. I am having difficult with Visual basic for Excel. is there any good sites on the net with information tutorials or even some books you could recommend. Thanks

Options

16-02-2002 1:36am

#1

irishgeo

Registered Users Posts: 9,443 ✭✭✭

Join Date: March 2001

Posts: 8831

I am a 4th year degree student in GMIT Galway. I am having difficult with Visual basic for Excel. is there any good sites on the net with information tutorials or even some books you could recommend.

Thanks

0

Comments

Options
#2 16-02-2002 3:52pm
Kali

Closed Accounts Posts: 6,601 ✭✭✭

Join Date: February 1998

Posts: 6297

http://www.vbweb.co.uk/show/35 is a good starting point for excel related macros...

0
Options
#3 17-02-2002 8:02am
marauder

Closed Accounts Posts: 285 ✭✭

Join Date: June 1999

Posts: 259

In my experience vb in excel, especially older versions is quite different from vb vb if you know what I mean. I used to do some work in vb on Access 97 and found the help files with it pretty useful, so I assume the online help with excel is similar...

0
Options
#4 17-02-2002 2:02pm
Evil Phil

Registered Users Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

A little tip on something I find helpful when trying to do stuff with office from vb or vba. Record a macro that does what you want then look at the code in the vba editor. Dead easy.

0