User defined functions can be created into the Microsoft spreadsheet Spreadsheets can be customized according to the user needs by using VB applications To create visual basic functions useful for spreadsheet you need to click Tools and select Macros where you will need to click on Visual basic editor
Technology problems
Search Results
1. What are the rules which should be followed while naming a variable in VB?
Correct Answer: Some of the rules which should be followed while naming a variable in VB are as follows: 1) Characters should be less than 255 2) Space between characters should be allowed 3) A variable should begin with a number 4) Period may not be permitted
2. How can visual basic be used for server side scripting?
Correct Answer: Visual basic can be used for server side scripting A component designed with Visual basic will not have any user interface instead provides the functionality of Active X to other programs via COM This form of technique allows server side functionality and add in module
3. What are the different ways to Declare and Instantiate an object in Visual Basic 6?
Correct Answer: Dim obj as OBJCLASS with eitherSet obj = New OBJCLASS orSet obj = CreateObject(OBJCLASS?) orSet obj = GetObject( , OBJCLASS?)orDim obj as New OBJCLASS
Correct Answer: DDE (Dynamic Data Exchange) a communication protocol that let applications call each other OLE was the first protocol that enabled users and programmers to create compound documents?that is documents that contain data from different applications (for example an Excel worksheet inside a Word document)
Correct Answer: Crypto usage in PHP is simple, but that doesn?t mean it?s free First off, depending on the data that you?re encrypting, you might have reasons to store a 32-bit value in the database instead of the 160-bit value to save on space Second, the more secure the crypto is, the longer is the computation time to deliver the hash value A high volume site might be significantly slowed down, if frequent md5() generation is required
10. Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example?
Correct Answer: In this example it wouldn?t matter, since the variable is all by itself, but if you were to print something like "{$a},000,000 mln dollars", then you definitely need to use the braces