Announcement

Collapse
No announcement yet.

Dim a Decimal

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dim a Decimal



    how come this feature is not available? How do I DIM a decimal? As a Variant?

  • #2
    Re: Dim a Decimal

    Try Double or Single.
    Boo!

    Comment


    • #3
      Re: Dim a Decimal

      Try this
      Code:
      Option Explicit
      
      Sub test()
          Dim x As Double
          x = 5 / 2
          MsgBox x
      End Sub
      Hope that Helps

      Roy

      New users should read the Forum Rules before posting

      For free Excel tools & articles visit my web site

      If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

      RoyUK's Web Site

      royUK's Database Form

      Where to paste code from the Forum

      About me.

      Comment


      • #4
        Re: Dim a Decimal

        thank you fine sirs worked great

        (just working up that beer count aren't you Roy...)

        Comment


        • #5


          Re: Dim a Decimal

          You will never set foot in the UK I suspect, you will have to buy a brewery.
          Hope that Helps

          Roy

          New users should read the Forum Rules before posting

          For free Excel tools & articles visit my web site

          If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

          RoyUK's Web Site

          royUK's Database Form

          Where to paste code from the Forum

          About me.

          Comment

          Working...
          X