GTU previous years question papers
GUJARAT TECHNOLOGICAL UNIVERSITY
B.E. Sem-Vth Examination December 2010
Subject code: 15 06
Subject Name: Visual Basic Applications and Programming
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (a) What is VBA? State the Difference between VB & VBA
(b) Define Array.Explain Fixed and Dynamic Array with example.
(c) How the variable is declare and discribe the different types of Variables with example.
Q.2 (a)(i) How Do…While loop is executed ?Explain in Brief With Example
(ii) Explain following properties of Listbox control:
1. List count 01
2. Multiselect 01
3. ListIndex 01
(b) What are Events? Explain Mouse Event in brief with example.
(b) Explain configuration Macro security setting in detail.
Q.3 (a) Write step for creating and executing Macros
(b) What is Procedure? Define the scope of private and public procedure with example
(c) Write a program to enter the year and check whether it is leap year or not.
Q.3 (a) What is command bar? Explain Brief to create menu bar and explain how to create shortcut keys in menu.
(b) Explain the Four different types of Operators with example.
(c) Write common Method for control.
Q.4 (a) Write a VB Program to implement Standard Calculator.
(b) How to create a new document in VBA?
(c) Explain Frame control with its different properties.
Q.4 (a) A form has File Handling Controls to view Picture file name from a path
of drive and folder one picture box to display selected Picture file. Write appropriate program for this application
(b) Explain the following function with example
1. ABS() 02
2. MOD() 02
3. IsDate() 02
4. LCase() 01
Q.5 (a) Write a procedure to access the database using ActiveX control
(b) Discuss the following:
1. Property window 01
2. Object Browser 01
3. Break Points 01
(c) Explain Timer Control with its properties
Q.5 (a) Define function.How to pass arguments in function?
(b) Describe MSGBOX() and INPUTBOX() with example
(c) Explain Error Handling .