Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Visual basic and MS Excel

08 Apr 2014   #1

Windows 7 Professional 64 bits
Visual basic and MS Excel

How much more would I be able to do in Excel if I knew Visual Basic

My System SpecsSystem Spec
08 Apr 2014   #2


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
My System SpecsSystem Spec
08 Apr 2014   #3

Linux Mint 17 Cinnamon | Win 7 Ult x64

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 System SpecsSystem Spec

08 Apr 2014   #4

Windows 7 Professional 64 bits

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 System SpecsSystem Spec

 Visual basic and MS Excel

Thread Tools

Similar help and support threads
Thread Forum
Visual Basic Skin
I was wondering how I could change every look and feature for my upcoming project in Visual Basic. As you can see in the link provided below, the Visual Basic installer has basically it's own theme. Dark background. Customize exit and minimize icons and buttons. So how to I "skin" a Visual Basic...
Chillout Room
Microsoft Visual Basic 6
Where can I download Microsoft Visual Basic 6? I have tried using a program and it requires that in order to compile a stub. Anyways here is a screenie.
Visual Basic 6
Guys n Gals Any of you know where I might be able to locate a copy of VB6 Professional or Enterprise ? I have a licence key but need the installation media.
Chillout Room
Visual Basic 6.0 on Windows 7
Is there a version of Visual Basic 6.0 that actually works with Windows 7 without having the need to use Windows XP Mode? The ones I downloaded off the internet had trouble installing in Windows 7 but runs just fine on Windows XP. It's VB6.0 Enterprise that I tried to use by the way. .
Visual Basic
I am having a go at Visual Basic Express 2008 and looking for books or websites for training. One thing has me confused what is the difference between Visual Basic Express 2008 and Visual Studio 2008? I would also like to know of any good websites for training. Thanks jack
Visual basic 6 & W7 ??
Slowly starting to restore all my programs that ran on WinXP. Seems most of the *.exe programs are running but a few that didn't run I tried to reconstruct them and it appears I need some more dll's. I can't remember if there were 2 CD's that came with VB6 PE. Before I start tearing my computer...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:47.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App