using hash(#) in vba [duplicate]
This question already has an answer here:
#if, #else, #end if … what do the hash signs mean in VBA?
2 answers
Can someone clarify why I have to use a # here?
#If Win64 Then
do something
#Else
do something else
#End If
excel vba excel-vba
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
marked as duplicate by John Coleman, Luuklag, QHarr vba
Users with the vba badge can single-handedly close vba questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 '18 at 12:17
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
#if, #else, #end if … what do the hash signs mean in VBA?
2 answers
Can someone clarify why I have to use a # here?
#If Win64 Then
do something
#Else
do something else
#End If
excel vba excel-vba
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
marked as duplicate by John Coleman, Luuklag, QHarr vba
Users with the vba badge can single-handedly close vba questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 '18 at 12:17
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
#if, #else, #end if … what do the hash signs mean in VBA?
2 answers
Can someone clarify why I have to use a # here?
#If Win64 Then
do something
#Else
do something else
#End If
excel vba excel-vba
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
This question already has an answer here:
#if, #else, #end if … what do the hash signs mean in VBA?
2 answers
Can someone clarify why I have to use a # here?
#If Win64 Then
do something
#Else
do something else
#End If
This question already has an answer here:
#if, #else, #end if … what do the hash signs mean in VBA?
2 answers
excel vba excel-vba
excel vba excel-vba
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
edited Nov 20 '18 at 12:06
Luuklag
3,37492742
3,37492742
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
asked Nov 20 '18 at 11:59
VilhelmPVilhelmP
1
1
marked as duplicate by John Coleman, Luuklag, QHarr vba
Users with the vba badge can single-handedly close vba questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 '18 at 12:17
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by John Coleman, Luuklag, QHarr vba
Users with the vba badge can single-handedly close vba questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 '18 at 12:17
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Prefixing with a # means you are specifying compiler directives and compiling different sets of code depending on values that have been predefined e.g Win64 or which you have defined yourself by adding values to Tools.PropertiesGeneral.Conditional Compilation Arguments.
https://docs.microsoft.com/en-us/office/vba/language/reference/directives
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Prefixing with a # means you are specifying compiler directives and compiling different sets of code depending on values that have been predefined e.g Win64 or which you have defined yourself by adding values to Tools.PropertiesGeneral.Conditional Compilation Arguments.
https://docs.microsoft.com/en-us/office/vba/language/reference/directives
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
add a comment |
Prefixing with a # means you are specifying compiler directives and compiling different sets of code depending on values that have been predefined e.g Win64 or which you have defined yourself by adding values to Tools.PropertiesGeneral.Conditional Compilation Arguments.
https://docs.microsoft.com/en-us/office/vba/language/reference/directives
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
add a comment |
Prefixing with a # means you are specifying compiler directives and compiling different sets of code depending on values that have been predefined e.g Win64 or which you have defined yourself by adding values to Tools.PropertiesGeneral.Conditional Compilation Arguments.
https://docs.microsoft.com/en-us/office/vba/language/reference/directives
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
Prefixing with a # means you are specifying compiler directives and compiling different sets of code depending on values that have been predefined e.g Win64 or which you have defined yourself by adding values to Tools.PropertiesGeneral.Conditional Compilation Arguments.
https://docs.microsoft.com/en-us/office/vba/language/reference/directives
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
answered Nov 20 '18 at 12:04
FreeflowFreeflow
551128
551128
add a comment |
add a comment |
