Log in

View Full Version : Where to focus my attention??



gringo287
01-07-2014, 09:51 AM
How do,

I've been telling myself to post this thread for too long!.

After DRJ recommended the; Microsoft Virtual Academy (http://www.microsoftvirtualacademy.com/?mtag=MVP4039979), I can't really hold it off any longer.

I have a habit of waffling on.., so I'll keep this brief



There isn't a single area of IT, that I don't find fascinating
This means, I find it incredibly difficult to work out, exactly, what I want to be "When I grow up" .. I'm 33!!
Excel has been my best friend for around 3 years now, as its helped my get "My name" around at work, so I've completed various projects, I wouldn't have been considered for otherwise
Excel is, in itself, part of the problem.
Excel, in all its awesomeness, has its limitations and most of all, I know very people that are't scared of it. So, no matter how many hours/days, I spend on a project, It quickly fizzles out, due to the users' trepidation around using Excel.
I'm reasonably confident, that I'd be well suited to software development (PLEASE feel free to correct me!!), as I have mostly enjoyed learning VBA, while using excel and creating userform based applications.
All the different language options, regarding anything other than using excel, scare me, and to be honest, I just don't have a clue where to start.
Which language is the best to start with?
I'm terrible at reading books!!.


I'm sure that the MVA will help a lot, but still, I would love some guidance, on the first steps

SamT
01-07-2014, 11:26 AM
Which language is the best to start with?

Depends on which Programming Domain (https://en.wikipedia.org/wiki/Programming_domain) you are most interested in.

gringo287
01-07-2014, 01:42 PM
Thank you, SamT,

Out of that list, I'm thinking General purpose Applications (https://en.wikipedia.org/wiki/Application_software).

At the risk of sounding lazy.. Is there a This is what you need and this is where you should start?. It just feels like there are too many choice's, even on that Wiki page

SamT
01-08-2014, 10:11 AM
Just my :2p:

I took the time to review the code in several of your uploads and, honestly, I think you will greatly benefit from any organized course of instruction in any language.

TIOBE Software: Tiobe Index (http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html)

I think you should take a good look at Visual Basic.

You should consider your goal as a ten year long project.

gringo287
01-11-2014, 07:07 AM
Thank you SamT,

Your 2 Cents, is worth much more! :pleased:

I think Visual Basic, will surely be a good place dig into.

Thank you for your diplomacy.. by the way, I approeciate, that my VBA, probably looks like a car wreck to you.

Paul_Hossler
01-19-2014, 09:40 AM
Oldie, but a goodie

http://www.amazon.com/Code-Complete-Practical-Handbook-Construction/dp/0735619670/ref=sr_1_1?s=books&ie=UTF8&qid=1390148815

Paul

dirtychinch
02-20-2014, 09:12 AM
Could start with a bit of focus on commas! Jeez

James88
04-24-2015, 05:05 PM
I'm quite new to all this too..Launching into Visual Basic and it's becoming a good hobby although I wish I could dedicate more time to it. Is your knowledge to date all self taught?

gringo287
04-27-2015, 03:20 PM
Hi James88. Sorry for the late response. I wouldn't say self taught, as I've had a loads of amazing assistance from the guys on here and obviously I rely on Google and Youtube. I've actually not done anything for around 6 months, due to my little boy being born and taking up all my time. I'm working on/reviving an old project as we speak and upto now, I've not needed to post any questions on here, so I'm doing ok.

Ha Ha DirtyChinch, I have no excuses for my bad grammar :whistle::whistle:

markecb
01-15-2016, 02:27 PM
Mabe to try something like Coursera?

SamT
01-15-2016, 05:23 PM
At it's most basic definition, VBA is a scripting language for Object Model type Applications. The most important step to becoming a good VBA programmer is to understand the Object Model of the application (Excel's is simplest, IMO,) and the Object Model of VBA.

IF your Version of Office doesn't have a built-in help file, I can upload some old standalone MS Office help files, to that you can easily navigate them. Online navigation is slow and cumbersome.

The first major thing that I did when learning VBA (for Excel) was to transfer every bit of data in the Help files to an Object Model in an Excel Workbook. That was with Excel 97 in 2002 and I still refer to that Workbook today.

I have attached an xlsm copy of that Workbook.