Difference between Userform Activate and Initialize

  • Thread starter Thread starter shahzad4u_ksa
  • Start date Start date
S

shahzad4u_ksa

Hi,

I need some information regarding the Userform Activate and
Initialize.

and Dim Statement, Intiger and String what is this.

I am new in this field and many time using this but I want some
explanation.

Regards.

Shahzad
 
Hi,

I need some information regarding the Userform Activate and
Initialize.

and Dim Statement, Intiger and String what is this.

I am new in this field and many time using this but I want some
explanation.

Regards.

Shahzad
Click to expand...

Hello Shahzad,

A UserForm is a special window called a Dialog. Before a Window is
displayed , it must have the information needed to display correctly.
This process is called Initialization. Once the Window has the
necessary information to be created, it is loaded into memory, and can
now respond to user inputs and code routines. The UserForm is now
Active.

The Dim statement is used to declare an object as a particular type.
For example, Dim N As Integer. The variable N is now a 16 number. If
you Dim N As Long, it is now a 32 bit number. Strings can hold both
numbers and text, and limited in size to 2 billion bytes (2 GB). The
reality is the string is limited by available memory.

Sincerely,
Leith Ross
 
HelloShahzad,

A UserForm is a special window called a Dialog. Before a Window is
displayed , it must have the information needed to display correctly.
This process is called Initialization. Once the Window has the
necessary information to be created, it is loaded into memory, and can
now respond to user inputs and code routines. The UserForm is now
Active.

The Dim statement is used to declare an object as a particular type.
For example, Dim N As Integer. The variable N is now a 16 number. If
you Dim N As Long, it is now a 32 bit number. Strings can hold both
numbers and text, and limited in size to 2 billion bytes (2 GB). The
reality is the string is limited by available memory.

Sincerely,
Leith Ross
Click to expand...

Dear Ross,

Thank you for your quick reply. I appreciated.

Thank you for sending me the concept of the above problem. Now I
understand.

with best regards.

Shahzad
 
Back
Top