When.com Web Search

Search results

  1. Results From The WOW.Com Content Network
  2. Visual Basic for Applications - Wikipedia

    en.wikipedia.org/wiki/Visual_Basic_for_Applications

    As an example, VBA code written in Microsoft Access can establish references to the Excel, Word and Outlook libraries; this allows creating an application that – for instance – runs a query in Access, exports the results to Excel and analyzes them, and then formats the output as tables in a Word document or sends them as an Outlook email.

  3. Talk:Visual Basic for Applications - Wikipedia

    en.wikipedia.org/wiki/Talk:Visual_Basic_for...

    However, in Microsoft Excel, subroutines can write values or text found within the subroutine directly to the spreadsheet. The figure shows the Visual Basic code for a subroutine that reads each member of the x -column (named column variable x ), calculates its square, and writes this value into the corresponding y -column (also a named column ...

  4. Variant type (COM) - Wikipedia

    en.wikipedia.org/wiki/Variant_type_(COM)

    In Visual Basic a procedure argument can be declared to be optional by prefixing it with the Optional keyword. When the argument is omitted Visual Basic passes a special value to the procedure, called Missing in the table above, indicating that the argument is missing. Since the value could either be a supplied value or a special value, a ...

  5. Microsoft Excel - Wikipedia

    en.wikipedia.org/wiki/Microsoft_Excel

    Use of a user-defined function sq(x) in Microsoft Excel. The named variables x & y are identified in the Name Manager. The function sq is introduced using the Visual Basic editor supplied with Excel. Subroutine in Excel calculates the square of named column variable x read from the spreadsheet, and writes it into the named column variable y.

  6. Function (computer programming) - Wikipedia

    en.wikipedia.org/wiki/Function_(computer...

    Assign an identifier, name, to a function; Define formal parameters with a name and data type for each; Assign a data type to the return value, if any; Specify a return value in the function body; Call a function; Provide actual parameters that correspond to a called function's formal parameters; Return control to the caller at the point of call

  7. Spreadsheet - Wikipedia

    en.wikipedia.org/wiki/Spreadsheet

    However, in Microsoft Excel, subroutines can write values or text found within the subroutine directly to the spreadsheet. The figure shows the Visual Basic code for a subroutine that reads each member of the named column variable x, calculates its square, and writes this value into the corresponding element of named column variable y.

  8. Macro (computer science) - Wikipedia

    en.wikipedia.org/wiki/Macro_(computer_science)

    Visual Basic for Applications (VBA) is a programming language included in Microsoft Office from Office 97 through Office 2019 (although it was available in some components of Office prior to Office 97). However, its function has evolved from and replaced the macro languages that were originally included in some of these applications.

  9. Is functions - Wikipedia

    en.wikipedia.org/wiki/Is_functions

    The functions are simple data validation and data type checking functions. The data validation functions determine whether it is possible to convert or coerce the data value given as an argument to the function to the type implied by the function name, and return a Boolean value recording whether it was possible or not.