corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel and Visual Basic


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel and Visual Basic
fiestakidda
Member

Registered: 23rd Oct 02
Location: Darlington (Come On Boro)
User status: Offline
15th Sep 13 at 21:22   View User's Profile U2U Member Reply With Quote

I'm wanting too in my spare time learn more about excel in terms of formulas and functionality, also wanting to learn more about macros and Visual Basic coding.

Is anyone aware of any free online training or websites which provide guides on this type of thing?
Brett
Premium Member

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
16th Sep 13 at 01:45   View Garage View User's Profile U2U Member Reply With Quote

Sub Soz()
Msgbox "soz can't help ", vbinformation, "Sorry dude"
End Sub
Ste
Premium Member

Avatar

Registered: 5th Mar 03
Location: Taif, Saudi Arabia
User status: Offline
16th Sep 13 at 02:06   View Garage View User's Profile U2U Member Reply With Quote

Set fiestakidda.AbilityLevel = Nothing


I would rather lose by a mile because i built my own car, than win by an inch because someone else built it for me.
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
16th Sep 13 at 08:21   View User's Profile U2U Member Reply With Quote

Excel is a very useful skill to have, but I'm not sure if VBA (VB within Excel) is a particularly sought after skill outside a handful of industries. Something to consider.
A2H GO
Member

Registered: 14th Sep 04
Location: Stoke
User status: Offline
16th Sep 13 at 09:01   View User's Profile U2U Member Reply With Quote

I read a couple of books on VBA programming, might have the PDF's I can send through. In all honesty though, unless you're using it regularly/everyday you'll forget it pretty quickly.
ed
Member

Registered: 10th Sep 03
User status: Offline
16th Sep 13 at 09:13   View User's Profile U2U Member Reply With Quote

Are you wanting to learn about VBA for the purpose of learning about macro writing or are you wanting to learn it for general programming purposes? If it's the latter, avoid it like the plague! VBA is shite!

Saying that, Stack Overflow is a really good place to go when you've got programming problems. Have a search on there because loads of stuff has been covered

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1679
21st Mar 03 at 00:15
by Red_Corsa
 
Excel help Mark Petty Geek Day 7 275
18th Jul 05 at 17:41
by Mark Petty
 
Visual Basic stubs Geek Day 3 742
24th Oct 06 at 10:12
by James
 
Microsoft Excel strick206 Geek Day 10 1486
6th Jul 11 at 14:46
by Sam
 
Visual Basic in Excel fiestakidda Geek Day 2 233
13th Sep 12 at 19:31
by James
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel and Visual Basic 30 database queries in 0.0143909 seconds