## Dynamic Label and Textbox during runtime in excel vba

In userform we can insert Labels and Textboxes while designing. In this post you can learn how to create the label and text box dynamically during the runtime with the help of command button.

## How to use Excel EFFECT Function

Introduction:- EFFECT function in excel is a financial function. It is used to find effective annual interest rate. It is defined as the actual interest rate earned annually due to compounding. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =EFFECT(nominal_rate, npery) Arguments:- Nominal_Rate: It is […]

## How to use Excel ERROR.TYPE Function

Introduction:- ERROR.TYPE function in excel is an information function. It is used to retrieve a number corresponding to an error value. If there is no error than #N/A is displayed. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ERROR.TYPE(error_value) Arguments:- Error_Value: The error value whose […]

## How to use Excel DURATION Function

Introduction:- DURATION function in excel is a financial function. It is used to find duration of a security in Macaulay form using Macaulay duration formula. Duration is expressed as weighted average of cash flows at present. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DURATION […]

## How to use Excel FV Function

Introduction:- FV function in excel is a financial function. It is used to find the future value of an investment. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FV (rate, nper, pmt, [pv], [type]) Arguments:- rate – It is the interest rate per period. nper – It […]

## How to use Excel DISC Function

Introduction:- DISC function in excel is a financial function. It is used to find discount rate of a security. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DISC(settlement, maturity, pr, redemption, basis) Arguments:- Settlement: It is the date on which security is settled. It comes […]

## How to use Excel FVSHEDULE Function

Introduction:- FVSCHEDULE function in excel is a financial function. It is used to find the future value of an initial principal after a number of compound interest rates. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FVSCHEDULE (Principal, Schedule) Arguments:- Principal: It is the present […]

## How to use Excel DDB Function

Introduction:- DDB function in excel is a financial function. It is used to return the depreciation value of an asset during a mentioned period by using double declining balance method or other methods mentioned in Factor argument. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- […]

## How to use Excel INTRATE Function

Introduction:- INTRATE function in excel is a financial function. It is used to find interest rate of a fully invested security. It is a worksheet function and can be entered in the cell in which value is required. . Syntax:- =INTRATE(settlement, maturity, investment, redemption, basis) Arguments:- Settlement: It is the date on which security is […]

## How to use Excel ISBLANK Function

Introduction:- ISBLANK function in excel is an information function. It is used to find out whether cells are empty. It returns TRUE if cell is empty otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISBLANK(VALUE) Arguments:- Value: It is the value which […]