Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Need to learn VBA asap
New Posts  All Forums:Forum Nav:

Need to learn VBA asap

post #1 of 3
Thread Starter 
Hi folks,

I'm looking for some opinions on the best approach to learning VBA - it would be self taught via books or some sort of online resource. Primary goal is to write highly complex and customizable macros in Excel. Can anyone recommend a good starter guide?

Thank you very much!

Edit - also, is there anyone I could kindly talk to about the programming industry in general - I'm looking to make the switch over from computational finance/trading. Computers have always been my passion
Edited by MLJS54 - 2/9/11 at 6:47pm
Skylake + Pascal
(18 items)
 
  
CPUMotherboardGraphicsRAM
i5 6600k ASUS ROG Maximus VIII Gene Gigabyte GTX 1070 G1 Gaming G. Skill Trident Z 16GB 
Hard DriveHard DriveCoolingOS
Crucial M.2 250GB SSD Samsung 850 EVO 500GB SSD Corsair H100i Windows 10 64bit 
MonitorKeyboardPowerCase
Dell S2716DG 144hz G-Sync Logitech G610 MX Red EVGA G2 750W Corsair Air 240 
MouseMouse PadAudioAudio
BenQ Zowie FK2 QcK+ Sennheiser HD 650 Schiit Vali 1 
Audio
Schiit Modi 1 
  hide details  
Reply
Skylake + Pascal
(18 items)
 
  
CPUMotherboardGraphicsRAM
i5 6600k ASUS ROG Maximus VIII Gene Gigabyte GTX 1070 G1 Gaming G. Skill Trident Z 16GB 
Hard DriveHard DriveCoolingOS
Crucial M.2 250GB SSD Samsung 850 EVO 500GB SSD Corsair H100i Windows 10 64bit 
MonitorKeyboardPowerCase
Dell S2716DG 144hz G-Sync Logitech G610 MX Red EVGA G2 750W Corsair Air 240 
MouseMouse PadAudioAudio
BenQ Zowie FK2 QcK+ Sennheiser HD 650 Schiit Vali 1 
Audio
Schiit Modi 1 
  hide details  
Reply
post #2 of 3
I started programming by looking at other peoples code and editing it to see what effect it has on the program.

Overall, I find the resources online much more helpful than books.

PM me if you have any questions. I don't know Visual Basic, but I know C, C++, Java, PHP, etc.
Big Red
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i7 920 D0 @ 3.7Ghz EVGA x58 x3 SLI GTX260 6gb Dominator 1600 
Hard DriveOSMonitorPower
(4)WD 500GB RE3 in RAID 0 (2) Seagate 1TB's Windows 7 + Fedora 11 Dual HP w2408 Corsair TX850W 
CaseMouseMouse Pad
Dell XPS 710 (Red/Silver) Logitech G9 Grey :p 
  hide details  
Reply
Big Red
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i7 920 D0 @ 3.7Ghz EVGA x58 x3 SLI GTX260 6gb Dominator 1600 
Hard DriveOSMonitorPower
(4)WD 500GB RE3 in RAID 0 (2) Seagate 1TB's Windows 7 + Fedora 11 Dual HP w2408 Corsair TX850W 
CaseMouseMouse Pad
Dell XPS 710 (Red/Silver) Logitech G9 Grey :p 
  hide details  
Reply
post #3 of 3
you can record macros and it'll write the code for it. Use that if you get stuck figuring something out.
weehee
(21 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 Asus Rampage II Gene MSI GTX660 Ti Corsair Vengeance 
Hard DriveHard DriveHard DriveHard Drive
Corsair SSD Intel SSD Western Digital Black  Western Digital Green 
Optical DriveCoolingOSMonitor
people still use DVDs? Corsair H60 Windows 8.1 x64 Professional Asus VG248QE 
MonitorMonitorKeyboardPower
Asus VW266H Qnix QX2710 Logitech G15 XFX Black Edition (Seasonic) 750w Modular 
CaseMouseMouse PadAudio
Antec P180 Mini MX518 Standard Audinst - HUD-mx1 
Audio
Beyerdynamic DT990 
  hide details  
Reply
weehee
(21 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 Asus Rampage II Gene MSI GTX660 Ti Corsair Vengeance 
Hard DriveHard DriveHard DriveHard Drive
Corsair SSD Intel SSD Western Digital Black  Western Digital Green 
Optical DriveCoolingOSMonitor
people still use DVDs? Corsair H60 Windows 8.1 x64 Professional Asus VG248QE 
MonitorMonitorKeyboardPower
Asus VW266H Qnix QX2710 Logitech G15 XFX Black Edition (Seasonic) 750w Modular 
CaseMouseMouse PadAudio
Antec P180 Mini MX518 Standard Audinst - HUD-mx1 
Audio
Beyerdynamic DT990 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Need to learn VBA asap