Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm initialize event run when UserForm is shown | Excel Programming | |||
initialize value in userform when opened | Excel Programming | |||
UserForm initialize | Excel Programming | |||
userform initialize | Excel Programming | |||
initialize userform, using a sub | Excel Programming |