Computing.Net > Forums > Programming > VBA to VB...

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

VBA to VB...

Reply to Message Icon

Original Message
Name: LockerRoom
Date: October 8, 2003 at 12:59:42 Pacific
Subject: VBA to VB...
OS: XP
CPU/Ram: 2Gigram 2Ghz
Comment:

I am quite enamoured with VBA in excel, love it for creating macros but the process of the programming seems limited, only allowing me to use Excel as a DB with cells but it isnt what i need

I want to create my own exe's, my own programs and to do this then the next step is getting Visual Basic

Is it written using the same logical programming language? Is the transition between the two rough and if so is there any good online sources that go deep into a beginners upto an advanced guide into using Visual Basic?

Its a lot of money to buy so before i go ahead id love to hear some feedback from you guys

Creating a game in Excel means that my users are going to not only need excel but it doesnt allow me as much freedom for inputing information and all of the source data is available for them to mess with :)

Thanks in advance, email or reply here

Cheers


Report Offensive Message For Removal


Response Number 1
Name: Global
Date: October 10, 2003 at 02:32:38 Pacific
Reply: (edit)

VBA to VB is often a natural 'step up' in programming terms.

Excel code is pretty much re-usable in the VB environment and the code does not often change.

What is important is that you understand how VB behaves with Excel, Excel to VB is just another object that has properties methods events etc. VB has a wonderful tool called the object browser so you can see all the capabilities an Excel object has.

Once you get the mindset right then you are away!!!!

I am not sure what other forum users would recommend but I would look to record/program macros and lift the code into VB and take it from there.

Like I said, it is a natural progression really and it seems that you are more than half the way there anyway.

Have fun!

Regards
GLOBAL

PS
I have loads of examples in VB which I have no problem in supplying to you if required.

PPS
Why would anyone want to write a game in Excel anyway???? :o)



Report Offensive Follow Up For Removal







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home








Do you have your own blog?

Yes
No
I did before
I will soon


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History




Data Recovery Software