what is # in vb?

[khaleefa]

Hi All,

I've to fix an old vb6 code and I've encounter the following lines

hours = 300#
if test * 100#/hours = abc then
' do something
end if

what is this # doing in the above code? I've never seen it before. I am completely stuck and can't move forward in my work until i figure out what this # is.

thank you very much

[|2eM!x]

I think it forces the number into double (if not its single or currency)

[si_the_geek]

Moved from CodeBank

Hi khaleefa, welcome to VBForums!

The # is a shortcut for the data type Double, so this:

Dim a#

is the same as:

Dim a as Double

In your example it is just ensuring that the numbers 100 and 300 are worked with as Double rather than integer (I'm not sure why tho!).

[khaleefa]

great, thank you veryyy much for your help (both of you

[w00dy]

Just like to add for Khaleefa's benefit,

! = Single
& = Long
@ =Currency

[khaleefa]

oh GOD, why couldn't they do it a simpler and more logical way?

anyways thank you W00dy

[Joacim Andersson]

% = Integer
$ = String

In your example it is just ensuring that the numbers 100 and 300 are worked with as Double rather than integer (I'm not sure why tho!).

Well VB treats numbers without a decimal as Integers unless they are to large in which case a Long is automatically used. By adding the # sign after those integer numbers VB will treat it as a Double already at compile time which makes the code run slightly faster since VB doesn't need to convert the Integer into a Double at run-time.