You are here:

Visual Basic/VBA word or excel

Advertisement


Question
I have a form that is produced everyday, this form has variables, like which unit, whine line, etc... I do not know how to ask this question, but basically , how would I make an application that would open by asking "Which unit?", "which line?", then generate form for preview then print?
AND, what would be the BEST way for me from going from knowing little about VBA to functional within it. I know the more I use it the better I will get. I have purchased VBA for dummies, and other software, but i get to a point I need a question answered and have no one to ask. My local college does not offer this course, or at least the person I talked to said it didn't. Any help would be greatly appreciated.

Answer
Dear Douglas,

To solve problems like this you need to study Excel advanced features. And it is not necessary go to college - you can get this info online.

Try those links:

http://www.techhive.com/article/256530/how_to_create_advanced_microsoft_excel_sp

This link has detailed explanation how to use VBA code and all the code also:

http://www.excelcrazy.com/how-to-create-usersform-in-excel-vba-macros.html

You can look at this vodeo also:

http://www.youtube.com/watch?v=j3c_LhE3pqg

Those materials will give you an idea how to use advanced Excel features.  Study them carefully and then use those features to solve your problem.

Regards,

Vitaliy

Visual Basic

All Answers


Answers by Expert:


Ask Experts

Volunteer


VITALY

Expertise

Area of expertise is Visual Basic .NET (VS 2008 and Framework 3.5) design and development for Windows applications. You can ask me any Visual Basic questions and some questions about .NET Framework. You can also ask me how to use Component One controls in Visual Basic. Do not ask me questions about Web design and development in Visual Basic.

Experience

I'm working as VB programmer from 1997, so I have a lot of experience with Visual Basic .NET as well as Visual Basic 6. Area of expertise is Visual Basic .NET (VS 2008 and Framework 3.5) design and development for Windows applications; Component One controls for Visual Basic; User controls; Moving VB6 applications to .NET.

Education/Credentials
B.S. in Computer Science

©2016 About.com. All rights reserved.