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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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

16-02-2002 12:36am

#1

irishgeo

Registered Users, Registered Users 2 Posts: 9,604 ✭✭✭

Join Date: March 2001

Posts: 8985

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

#2 16-02-2002 2: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
#3 17-02-2002 7: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
#4 17-02-2002 1:02pm

Evil Phil

Registered Users, Registered Users 2 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