Excel Programming (VBA)

Post by **Pext** » Thu Feb 17, 2005 10:13 am

As i'm currently doing some research in prime numbers, i decided to collect some data i need for my maths with excel, as it allready includes a good ways to represent the data after creating the numbers (colouring certain cells, etc...).

But as i don't know shit about vba - and as google is full of payed ad-links when it comes to excel - it'd be nice if someone could point me to a free internet resource on vba programming. I allready know C and Java btw, so i dont need general programming info ...

Things i need to know:

1 - how are simple functions implemented for excel/basic.
something like:

Code: Select all

void bla(int x, string y)
{
    // - code - 
}

2 - how to access (in/out) a certain cell in a certain document by its index

hm... i think that's all.

Guest · Post by **Guest** » Thu Feb 17, 2005 11:49 am

Getting ready for work so I gotta make this quick.

vbcity

Check that place out. It's been very helpfull for me. There's a forum specifically for VBA and excel.

Post by **Pext** » Thu Feb 17, 2005 1:41 pm

thanks a lot.

btw - i just found a nerd joke.

Code: Select all

Dim sum ...

:icon19:

Post by **Shmee** » Tue Feb 22, 2005 1:51 am

vb is almost counter intuitive if you know any "real" (for want of a better term - don't crucify me if you worship VB) languages.

I mean, functions.... come on. No return? Small children can easilly understand the concept. What's with setting the function name equal to the result?

Post by **U4EA** » Tue Feb 22, 2005 7:37 am

Not a VB worshipper but it definitely has its uses. I'm not overly familiar with VB6 as I only used it for one uni project, but I've been professionally using VB.NET for our GUIs for a year now and it's pretty damn solid. Gets rid of a lot of old VB6 inconsistencies and crap, adds OO support not to mention .NET libraries and countless other improvements.

Post by **Shmee** » Wed Feb 23, 2005 3:29 pm

Oh yeah - to be sure. I was knocking the old VB6 and back. .Net is pretty much an improvement on everything.

Guest · Post by **Guest** » Thu Feb 24, 2005 6:15 am

How much different is VB.NET than VB6? Would there be a large amount of relearning?

Post by **U4EA** » Thu Feb 24, 2005 8:21 am

As I said, I'm not too familiar with VB6 but I'd guess a fair amount of learning would be in order.

Post by **Tormentius** » Thu Feb 24, 2005 8:28 am

U4EA wrote:As I said, I'm not too familiar with VB6 but I'd guess a fair amount of learning would be in order.

Yeah, I'd say quite a bit.

Guest · Post by **Guest** » Fri Feb 25, 2005 10:15 pm

What I was afraid of. Well, back to the books.....