Longs

• • Reply

  18 years ago

  by alexreg

  Alex

  London, United Kingdom

  Joined 19 years ago

  I am trying to multiply 255 by 255 and storing that into a long variable. I have tried many different things but I keep on getting the same error, Overflow. That large of a number should easily be abled to be stored in a long. This is the current code that does not work.
  

  
  Dim num As Long
  

  
  num = 255 * 255
  

  
  Very, very simple but it doesn't work! Could anybody help me. Thanks,
  

  
  Alex

  Report abuse
• • Reply

  18 years ago

  by Smile005

  Marc Pritchard

  Sunny Wales, UK, United States

  Joined 19 years ago

  Doesn't work on my computer, thats strange. All i can suggest is that you either use a string and input the result into the long variable, i.e.:
  

  
  

  Code:

  
  dim sNum as string
  dim Num as long
  

  
  sNum = "255" * "255"
  Num = cLng(sNum)
  

  
  

  
  or if its appropriate, square the value i.e.:
  

  
  

  Code:

  
  dim Num as long
  

  
  Num = 255^2
  

  
  

  
  Hope that helps.

  Report abuse
• • Reply

  18 years ago

  by liserdarts

  Nick Avery

  Nebraska, USA, United States

  Joined 19 years ago

  That is strange. Though I was able to do it like this
  

  
  Dim X As Long
     X = 255
     X = X * X
  

  
  and like this
  

  
  Dim X As Long
     X = CLng(255) * CLng(255)

  Report abuse
• • Reply

  18 years ago

  by Apoc

  Michael Gagne

  Dallas/Fort Worth, TX, United States

  Joined 19 years ago

  Why don't you just do this:
  

  
  

  Code:

  Dim X As Long
  

  
  X = 65025   ' 255 * 255 = 65025

  
  

  
  It's better to do your calculations on constants before runtime...
  

  Report abuse
• • Reply

  18 years ago

  by Thushan Fernando

  Thushan Fernando

  Australia :: Melbourne, Australia

  Joined 19 years ago

  Hmmm... I get an overflow error as well.. thats is really wierd. However heres a temporary work around:
  

  
  

  Code:

  
  Dim num As Long
  num = 255
  num = num * 255
  MsgBox num
  

  
  

  
  Hope that helps!
  

  Report abuse
• • Reply

  18 years ago

  by alexreg

  Alex

  London, United Kingdom

  Joined 19 years ago

  Thanks for the code that set the variable to a number and then multiplied the number by itself. That worked. I still don't really know why you can't do what I tried.
  

  
  Alex

  Report abuse
• • Reply

  18 years ago

  by the_liberator

  Dave

  Upper Hutt, New Zealand, New Zealand

  Joined 18 years ago

  well considering that computers don't multiply in decimal, it could have something to do with the binary mulitplication algorithm.

  Report abuse
• • Reply

  18 years ago

  by Thushan Fernando

  Thushan Fernando

  Australia :: Melbourne, Australia

  Joined 19 years ago

  well alex if it was my code your talking about(im a little which your talking about) its OK! I inquired with a VB Developer(from the MS Visual Basic Developer Team) and he tells me its an odd occurance. Unfortunetly it may not be corrected because SP5 was the last SP for teh VS6 series, now its .NET all the way!
  

  Report abuse