Search:

Type: Posts; User: quickbbbb

Page 1 of 2 1

by quickbbbb
Replies
1
Views
788

thank you
2. Thread: [RESOLVED] whether boolean has a symbol ?

by quickbbbb
Replies
32
Views
1,269

[RESOLVED] whether boolean has a symbol ?

hi

double = #
long = &
single = !
string = \$

whether boolean has a symbol ???
3. Thread: LET MS know you are using VB6

by quickbbbb
Replies
137
Views
7,813

Re: LET MS know you are using VB6

please tell me URL of top 10 data is where

thank you
4. Thread: what reason is may be VB.Net win C#

by quickbbbb
Replies
14
Views
813

Re: what reason is may be VB.Net win C#

The maximum quantity code of world is C , C code can easy move to C#

VB.Net can beyond C# . VB.Net is popular
5. Thread: what reason is may be VB.Net win C#

by quickbbbb
Replies
14
Views
813

what reason is may be VB.Net win C#

hi ~

https://www.tiobe.com/tiobe-index/

from 2018/08 VB.Net First win C#
6. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

...............
7. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

ok

refresh Function compare

Public Function compare(n1, n2)
If n1 = n2 Then compare = "get n1=n2 is True by n1 = n2 compare": Exit Function
If CDec(n1) = CDec(n2) Then compare =...
8. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

hi , Elroy

The above example why i use If CDec(n1) <> CDec(n2) Then .......

because as following

9. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

Elroy

following test implicit vs explicit are not any difference

Option Explicit
'
10. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

hi , Elroy

We can see Cdec() that it add very many 111111111 to n1 (a big value) to fill hole

Public Sub Form_Click()
11. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

Elroy , thank you very much

Great example

by quickbbbb
Replies
137
Views
7,813

..........
13. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

sorry , I made a mistake

Dim b1(1 To 32) As Byte
Dim b2(1 To 32) As Byte

should be change as

Dim b1(1 To 4) As Byte
Dim b2(1 To 4) As Byte
14. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

' test2 ==========

Private Declare Sub RtlMoveMemory Lib "kernel32" (pDst As Any, pSrc As Any, ByVal CB&)

15. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

Re: Cdec( ) is not Precision ??

' ====== test1

(1) Decimal_point_count = 8
is out range of IEEE effective single number of bits
get result : Csng(n) <> Csng( Cstr(n) )

(2) Decimal_point_count = 2
...
16. Thread: [RESOLVED] Cdec( ) is not Precision ??

by quickbbbb
Replies
18
Views
1,071

[RESOLVED] Cdec( ) is not Precision ??

CStr() , Cdec() is not Synchronize ?????

Randomize

Dim s As Single
17. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

Fabulous! thank you very much

========================

sorry every one, my english is poor , can not has full expression and understand what you say

Most of them are used almost Google...
18. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

Now I decided to accelerate it with multi cpu core

19. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

Is it possible to provide a URL?

thank you
20. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

after i get stock price ( float type ) , i need save stock price to file

so I need convert number to string

of course , i can save it to Binary file ( it will be no need to convert to...
21. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

VBA.Fix( ) has bug

sometime I use Fix() to get value , it return a round value
22. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

use int() function is my Negligence

my data amount very huge , i need a function faster than cstr()

vba.Cstr convert long type to String = 4 second
My.Cstr convert long type to String = 2...
23. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

my data amount very huge , i need a function faster than cstr()

vba.Cstr convert long type to String = 4 second
My.Cstr convert long type to String = 2 second

now i need let My.Cstr can...
24. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

Const s = 12345.6789

Const test_speed_loops = 10 ^ 6

TT = Timer

For k = 1 To test_speed_loops

aaaa\$ = cstr(s)
25. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

const decimal_part_length = 3

you mean round ( 123.456 , decimal_part_length ) ??

but you can not know in advance the decimal part length

d may be = 123.456789
d may be = 123.456
d may...
26. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

160115

=============================

160117
27. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

because really time consuming is Cdec() function and code For w = 1 To 10 ^ 9 .... Next
28. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

Re: How to fast split Number integet part and decimal part ?

so you need use

decimal_part = Cdec(d) - integer_part

but Cdec() is a slow function
29. Thread: [RESOLVED] How to fast split Number integet part and decimal part ?

by quickbbbb
Replies
51
Views
2,026

[RESOLVED] How to fast split Number integet part and decimal part ?

Const s = 12345.6789

Dim w As Long
Dim k As Long
Dim p As Long

Dim integet_part As Long
30. Thread: How to build SafeArray in VB.Net ?

by quickbbbb
Replies
11
Views
1,242

Re: How to build SafeArray in VB.Net ?

It concerning the ease of use and not easy to make mistakes

// VB6

Redim AR_001(-100 To 100) As long

ID = -100 ' ID Range = -100 ~ 100

AR_001(ID ) = AR_001(ID ) + Rnd
31. Thread: How to build SafeArray in VB.Net ?

by quickbbbb
Replies
11
Views
1,242

Re: How to build SafeArray in VB.Net ?

VB6 Array is SafeArray

I can tampered its memory pointer

example:

' VB6 Code

Redim AR_001(1 to 1000) as long
Redim AR_002(1 to 1000) as long
32. Thread: How to build SafeArray in VB.Net ?

by quickbbbb
Replies
11
Views
1,242

Re: How to build SafeArray in VB.Net ?

sorry , my english is poor , can not has full expression

by quickbbbb
Replies
11
Views
1,242

159773
34. Thread: How to build SafeArray in VB.Net ?

by quickbbbb
Replies
11
Views
1,242

Re: How to build SafeArray in VB.Net ?

SafeArray can be
(1) Lbound <> 0
(2) Bind your Unmanaged memory pointer
35. Thread: How to build SafeArray in VB.Net ?

by quickbbbb
Replies
11
Views
1,242

How to build SafeArray in VB.Net ?

Hi , all

How to build SafeArray ( int type ) in VB.Net and use the SafeArray in VB.Net ?

thank you very much
36. Thread: if there is any third party dropmenu as like excel combobox ?

by quickbbbb
Replies
9
Views
593

Re: if there is any third party dropmenu as like excel combobox ?

hi ChrisE

Let vb listview has dropdown list
37. Thread: if there is any third party dropmenu as like excel combobox ?

by quickbbbb
Replies
9
Views
593

Re: if there is any third party dropmenu as like excel combobox ?

dilettante , That’s impressive!
38. Thread: if there is any third party dropmenu as like excel combobox ?

by quickbbbb
Replies
9
Views
593

Re: if there is any third party dropmenu as like excel combobox ?

yes , but vb's popupmenu has no scrollbar

Flaw of excel combbox is must install MS office and not support mouse wheel
39. Thread: if there is any third party dropmenu as like excel combobox ?

by quickbbbb
Replies
9
Views
593

Re: if there is any third party dropmenu as like excel combobox ?

It is a big flaw.

When VB new form popup , host form will lost focus.

When Excel_Combbox popup , host form will not lost focus.
40. Thread: if there is any third party dropmenu as like excel combobox ?

by quickbbbb
Replies
9
Views
593

if there is any third party dropmenu as like excel combobox ?

if there is any third party dropmenu as like excel combobox ?

GIF show

https://i.imgur.com/9gpqlfb.gif
Results 1 to 40 of 67
Page 1 of 2 1

Featured