[belajar-excel] Range Nilai integer

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Range Nilai integer

Milis Belajar Excel mailing list
Salam BeExceller,


Saya lihat di internet nilai Integer rangenya sbb. : https://msdn.microsoft.com/en-us/library/06bkb8w2.aspx
Integer Data Type (Visual Basic)
Visual Studio 2015
Other Versions <javascript:void(0)>
[https://i-msdn.sec.s-msft.com/Areas/Epx/Content/Images/ImageSprite.png?v=636256477425040586]
Updated: July 20, 2015


For the latest documentation on Visual Studio 2017, see Visual Studio 2017 Documentation<http://docs.microsoft.com/visualstudio>.


Holds signed 32-bit (4-byte) integers that range in value from -2,147,483,648 through 2,147,483,647.


Saya coba di excel 2010 untuk test dengan menuju baris terakhir di Excel dengan code sbb. :


'=====


Private Sub CommandButton5_Click()


Dim x As Long


x = ActiveCell.End(xlDown).Row


MsgBox x


End Sub


'=====


Hasilnya 1.048.576


Tapi kalau saya ganti x dengan integer (Dim x as integer) ternyata hasilnya Error (Runtime error '6' over flow), kenapa ya ? Bukankah integer rangenya sampai 2,147,483,647 sesuai referensi dari Internet di atas ?.


Mohon pencerahannya.


Terima Kasih.



















image001.png (242 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Range Nilai integer

Milis Belajar Excel mailing list
Hai Tio,

Data type untuk VB/VBA (VB6.x sampai VB7.x) disini
<https://msdn.microsoft.com/en-us/library/aa263420(v=vs.60).aspx>.
atau di VBA Editor -> tekan F1 -> ditextbox search ketik Data Type Summary
-> lakukan search
atau rangkumannya disini
<http://b-excel.blogspot.co.id/2013/07/belajarvba-004-tipe-data-variabel.html>
.

Regards,
Kid





2017-04-05 15:24 GMT+07:00 Tio Adi Bayu Adjie [hidden email]
[belajar-excel] <[hidden email]>:

>
>
> Salam BeExceller,
>
>
>
> Saya lihat di internet nilai Integer rangenya sbb. :
> https://msdn.microsoft.com/en-us/library/06bkb8w2.aspx
> Integer Data Type (Visual Basic)
>
> *Visual Studio 2015 *
>
> Other Versions
>
> [image:
> https://i-msdn.sec.s-msft.com/Areas/Epx/Content/Images/ImageSprite.png?v=636256477425040586]
>
> Updated: July 20, 2015
>
> For the latest documentation on Visual Studio 2017, see Visual Studio
> 2017 Documentation <http://docs.microsoft.com/visualstudio>.
>
> Holds signed 32-bit (4-byte) integers that range in value from *-2,147,483,648
> through 2,147,483,647.*
>
> Saya coba di excel 2010 untuk test dengan menuju baris terakhir di Excel
> dengan code sbb. :
>
> ‘=====
>
> Private Sub CommandButton5_Click()
>
> *Dim x As Long*
>
> x = ActiveCell.End(xlDown).Row
>
> MsgBox x
>
> End Sub
>
> ‘=====
>
> Hasilnya 1.048.576
>
> Tapi kalau saya ganti x dengan integer (*Dim x as integer*) ternyata
> hasilnya Error (Runtime error ‘6’ over flow), kenapa ya ? Bukankah integer
> rangenya sampai 2,147,483,647 sesuai referensi dari Internet di atas ?.
>
> Mohon pencerahannya.
>
> Terima Kasih.
>
>
>
>
>
>
>
>
>
>
>
>
>

image001.png (238 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Range Nilai integer

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Hai Tio,

Data type untuk VB/VBA (VB6.x sampai VB7.x) disini
<https://msdn.microsoft.com/en-us/library/aa263420(v=vs.60).aspx>.
atau di VBA Editor -> tekan F1 -> ditextbox search ketik Data Type Summary
-> lakukan search
atau rangkumannya disini
<http://b-excel.blogspot.co.id/2013/07/belajarvba-004-tipe-data-variabel.html>
.

Regards,
Kid





2017-04-05 15:24 GMT+07:00 Tio Adi Bayu Adjie [hidden email]
[belajar-excel] <[hidden email]>:

>
>
> Salam BeExceller,
>
>
>
> Saya lihat di internet nilai Integer rangenya sbb. :
> https://msdn.microsoft.com/en-us/library/06bkb8w2.aspx
> Integer Data Type (Visual Basic)
>
> *Visual Studio 2015 *
>
> Other Versions
>
> [image:
> https://i-msdn.sec.s-msft.com/Areas/Epx/Content/Images/ImageSprite.png?v=636256477425040586]
>
> Updated: July 20, 2015
>
> For the latest documentation on Visual Studio 2017, see Visual Studio
> 2017 Documentation <http://docs.microsoft.com/visualstudio>.
>
> Holds signed 32-bit (4-byte) integers that range in value from *-2,147,483,648
> through 2,147,483,647.*
>
> Saya coba di excel 2010 untuk test dengan menuju baris terakhir di Excel
> dengan code sbb. :
>
> ‘=====
>
> Private Sub CommandButton5_Click()
>
> *Dim x As Long*
>
> x = ActiveCell.End(xlDown).Row
>
> MsgBox x
>
> End Sub
>
> ‘=====
>
> Hasilnya 1.048.576
>
> Tapi kalau saya ganti x dengan integer (*Dim x as integer*) ternyata
> hasilnya Error (Runtime error ‘6’ over flow), kenapa ya ? Bukankah integer
> rangenya sampai 2,147,483,647 sesuai referensi dari Internet di atas ?.
>
> Mohon pencerahannya.
>
> Terima Kasih.
>
>
>
>
>
>
>
>
>
>
>
>
>

image001.png (238 bytes) Download Attachment