Difference between Userform Activate and Initialize
 

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

Difference between Userform Activate and Initialize
 

On Jul 2, 11:39 pm, wrote:
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

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

Difference between Userform Activate and Initialize
 

On Jul 3, 10:17 am, Leith Ross wrote:
On Jul 2, 11:39 pm, wrote:

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

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

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