What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-01-22 02:56:23
xlvba check if bit is set in 64-bit longlong integer
'Extremely fast VBA function to test if a specified bit is set 'within a 64-bit LongLong integer. 'Bits are numbered from 0 to 63, so the first (least significant) bit 'is bit 0. 'Note: we do not inspect bit 63, the sign bit. 'Note: the LongLong data t... Add solution -
CSS 2022-01-21 23:40:33
how to style navbar-toggler-icon bootstrap 5
<!--HTML--> <button class="navbar-toggler custom-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded=&q... Add solution -
VBA 2021-12-23 17:05:25
excelvba Convert HEX string to Unsigned INT
'VBA function to convert a hexadecimal string into a decimal. Uses 'the Decimal Variant subtype to allow for much larger values than the 'worksheet function HEX2DEC() or CLng("&h" & HexVal) can achieve. It 'returns an UNSIGNED Decimal i... Add solution -
VBA 2021-11-22 05:28:12
excel vba test if target is a named range
'VBA inline code to test if Target is a named range: If Not Intersect(Target, [NamedRangeName]) Is Nothing Then If Target.Cells.Count = [NamedRangeName].Cells.Count Then If Target.row = NamedRange.row Then If Target.Column = Named... Add solution -
VBA 2021-11-20 21:55:13
xlvba function sheet exists
'VBA function to test if a sheet exists in the active workbook: Function IsSheet(n$) As Boolean IsSheet = Not IsError(Evaluate(n & "!a1")) End Function '----------------------------------------------------------------------- 'Same thi... Add solution -
VBA 2021-11-20 14:27:27
vba queue data structure
'VBA does not include a native QUEUE (FIFO: FIRST-In-FIRST-Out) memory 'structure. It is possible to implement a QUEUE using nothing but a native 'array or collection. 'However, the easiest solution is to have VBA create and use a .NET Queue: Set Queue ... Add solution -
VBA 2021-11-20 10:01:19
excelvba check if specific bits set in int32
'Fast VBA function to test if specific bits are set 'within a 32-bit Long integer. If ALL specified bits are set then 'this function returns True. If ANY of the specified bits are 'not set then this function returns False. 'Bits are numbered from 0 to ... Add solution