If you have trouble viewing or submitting this form, you can fill it out
online:
https://docs.google.com/spreadsheet/viewform?fromEmail=true&formkey=dHRESnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ
VBA macro quiz #1
This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager
Your name *
Email Address *
1. Which of these is used at module level to force declaration of all
variables mandatory ? *
Option Compare
Option Variable
Option Explicit
Option Base
2. Which of these keyword is used to declare variables ? *
Declare
Dim
Create
Make
3. Which of these datatype is used in the variable declaration to store
text data ? *
String
Text
Char
Long
4. Which of these is correct declaration of macro ? *
Sub Welcome[]
Sub Welcome{}
Sub Welcome()
Sub Welcome
5. Which of these command is to display message in a dialog box ? *
ShowMsg
DialogBox
Message
Msgbox
6. Which of these is not a loop in VBA ? *
Do while
IF End if
For Next
While wend
7. Which of these command is used to take input from the user ? *
Inputbox
Textbox
InputText
InputValue
8. Which of these is a datatype used to store the decimal numbers in
variable ? *
Double
Decimal
Long
Float
9. Which of these command is used to stop screen flickering ? *
Application.HideScreen = True
Application.EnableEvents = False
Application.DisplayAlerts = False
Application.Screenupdating = False
10. Which is the file extension that cannot be used for macro excel file ? *
.XLSM
.XLSX
.XLSB
.XLS
Powered by Google Docs Report Abuse - Terms of Service - Additional Terms
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
