Visual basic and MS Excel

mohab

New member
Local time
4:11 PM
Messages
130
How much more would I be able to do in Excel if I knew Visual Basic
 

My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Optiplex 7020
OS
Windows 7 Professional 64 bits
CPU
Core i5 3.3 GHz
Motherboard
original
Memory
12GB
Graphics Card(s)
original (Intel HD graphics 4600
Monitor(s) Displays
Samsung SyncMaster 713N
Screen Resolution
1280 x 1024
Hard Drives
Kingstone SSDnow 480GB
Antivirus
Kaspersky Internet security 2016
Browser
Opera
VBA opens up a whole new world . Google "VBA Excel ebooks" and don't dismiss the dummies guide, very good for beginners, can free d/l
 
Just a completely obscure piece of rhetoric as I pass by..

Microsoft Excel is an extremely powerful set of tools, even without VB. It's amazing how many people turn to VB to do things that Excel can do natively.. Only twice have I ever had to resort to using VBA in an excel workbook, and some of my "programs" are pretty complicated.

But that's not to diminish the power of VB in Excel. PalBus is right, there is a lot more you can do with VBA.

VB does have a hit on your system though. Some advice - always see if there is a way to do it natively in Excel before you resort to writing VB scripts.

Good luck.
 

My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Home Made
OS
Linux Mint 17 Cinnamon | Win 7 Ult x64
CPU
Intel I7-3770K @ 4.2ghz
Motherboard
ASRock Extreme 4
Memory
32GB G-Skill C10Q
Graphics Card(s)
EVGA GTX 670 2GB SC
Sound Card
Creative Fatality ExtremeGamer
Monitor(s) Displays
LG E2742V x 2
Screen Resolution
1920x1080
Hard Drives
256GB Vertex 4 SSD
2TB Seagate ST2000DM001
1TB Seagate ST1000DM003
PSU
Corsair HX 650
Case
HAF 932 advanced
Cooling
Corsair H100i liquid cooler
Keyboard
Logitech Wireless
Mouse
Logitech Wireless
Internet Speed
OptusNet NBN 100/40
Antivirus
Malwarebytes
Browser
Firefox 30
Other Info
Router: Sagemcom F@st 3846 Crippled by Optus.
TanyaC, I agree with you that Excel is very powerful but flexible at the same time. I personally am amazed that a big software like Excel can operate on our machines ( as opposed to requiring a mini computer and a workstation). Whenever I thought that "no that's too complex for Excel" then I searched online, I would usually find a way to do it in Excel.
 

My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Optiplex 7020
OS
Windows 7 Professional 64 bits
CPU
Core i5 3.3 GHz
Motherboard
original
Memory
12GB
Graphics Card(s)
original (Intel HD graphics 4600
Monitor(s) Displays
Samsung SyncMaster 713N
Screen Resolution
1280 x 1024
Hard Drives
Kingstone SSDnow 480GB
Antivirus
Kaspersky Internet security 2016
Browser
Opera
Back
Top