Views

Histats

Vitrine

VBA Tips - Funções - Functions

Inline image 1

Será que você conhece algumas funções do VBA?

Funções

O que fazem

Abs

Retorna o valor absoluto de um número

Array

Returns a variant containing an array

Asc

Converts the first character of a string to its ASCII value

Atn

Returns the arctangent of a number

Choose

Returns a value from a list of items

Chr

Converts an ANSI value to a string

Cos

Returns a number's cosine

CurDir

Returns the current path

Date

Returns the current system date

DateAdd

Returns a date to which a specified time interval has been

 

added — for example, one month from a particular date

DateDiff

Returns an integer showing the number of specified time intervals between two dates, for example the number of months between now and your birthday

DatePart

Returns an integer containing the specified part of a given

 

date — for example, a date's day of the year

DateSerial

Converts a date to a serial number

DateValue

Converts a string to a date

Day

Returns the day of the month from a date value

Dir

Returns the name of a file or directory that matches a pattern

Erl

Returns the line number that caused an error

Err

Returns the error number of an error condition

Error

Returns the error message that corresponds to an error number

Exp

Returns the base of the natural logarithm (e) raised to a power

FileLen

Returns the number of bytes in a file

Fix

Returns a number's integer portion

Format

Displays an expression in a particular format

GetSetting

Returns a value from the Windows registry

Hex

Converts from decimal to hexadecimal

Hour

Returns the hours portion of a time

InputBox

Displays a box to prompt a user for input

InStr

Returns the position of a string within another string

Int

Returns the integer portion of a number

IPmt

Returns the interest payment for an annuity or loan

IsArray

Returns True if a variable is an array

IsDate

Returns True if an expression is a date

IsEmpty

Returns True if a variable has not been initialized

IsError

Returns True if an expression is an error value

IsMissing

Returns True if an optional argument was not passed to a procedure

IsNull

Returns True if an expression contains no valid data

IsNumeric

Returns True if an expression can be evaluated as a number

IsObject

Returns True if an expression references an OLE Automation object

LBound

Returns the smallest subscript for a dimension of an array

LCase

Returns a string converted to lowercase

Left

Returns a specified number of characters from the left of a string

Len

Returns the number of characters in a string

Log

Returns the natural logarithm of a number to base e

LTrim

Returns a copy of a string, with any leading spaces removed

Mid

Returns a specified number of characters from a string

Minute

Returns the minutes portion of a time value

Month

Returns the month from a date value

MsgBox

Displays a message box and (optionally) returns a value

Now

Returns the current system date and time

RGB

Returns a numeric RGB value representing a color

Right

Returns a specified number of characters from the right of a string

Rnd

Returns a random number between 0 and 1

RTrim

Returns a copy of a string, with any trailing spaces removed

Second

Returns the seconds portion of a time value

Sgn

Returns an integer that indicates a number's sign

Shell

Runs an executable program

Sin

Returns a number's sine

Space

Returns a string with a specified number of spaces

Sqr

Returns a number's square root

Str

Returns a string representation of a number

StrComp

Returns a value indicating the result of a string comparison

String

Returns a repeating character or string

Tan

Returns a number's tangent

Time

Returns the current system time

Timer

Returns the number of seconds since midnight

TimeSerial

Returns the time for a specified hour, minute, and second

TimeValue

Converts a string to a time serial number

Trim

Returns a string without leading or trailing spaces

TypeName

Returns a string that describes a variable's data type

UBound

Returns the largest available subscript for an array's dimension

UCase

Converts a string to uppercase

Val

Returns the numbers contained in a string

VarType

Returns a value indicating a variable's subtype

Weekday

Returns a number representing a day of the week

Year

Returns the year from a date value


Tags: Office, functions


André Luiz Bernardes

LinkWithinBrazilVBAExcelSpecialist

Related Posts Plugin for WordPress, Blogger...