Results 1 to 26 of 26

vba userform - how to sum values decimal and integer?

Threaded View

homasa vba userform - how to sum... 01-31-2011, 11:05 AM
StephenR Re: vba userform - how to sum... 01-31-2011, 11:23 AM
homasa Re: vba userform - how to sum... 01-31-2011, 11:28 AM
homasa Re: vba userform - how to sum... 01-31-2011, 11:32 AM
StephenR Re: vba userform - how to sum... 01-31-2011, 11:34 AM
homasa Re: vba userform - how to sum... 01-31-2011, 11:42 AM
StephenR Re: vba userform - how to sum... 01-31-2011, 11:49 AM
homasa Re: vba userform - how to sum... 01-31-2011, 12:04 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 12:14 PM
homasa Re: vba userform - how to sum... 01-31-2011, 12:26 PM
homasa Re: vba userform - how to sum... 01-31-2011, 12:36 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 12:37 PM
homasa Re: vba userform - how to sum... 01-31-2011, 12:51 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 01:14 PM
homasa Re: vba userform - how to sum... 01-31-2011, 01:24 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 01:29 PM
homasa Re: vba userform - how to sum... 01-31-2011, 02:18 PM
homasa Re: vba userform - how to sum... 01-31-2011, 03:24 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 03:31 PM
homasa Re: vba userform - how to sum... 01-31-2011, 03:35 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 03:41 PM
homasa Re: vba userform - how to sum... 01-31-2011, 03:44 PM
StephenR Re: vba userform - how to sum... 01-31-2011, 03:47 PM
homasa Re: vba userform - how to sum... 01-31-2011, 04:02 PM
homasa Re: vba userform - how to sum... 02-01-2011, 05:48 AM
steve05_83 Re: vba userform - how to sum... 03-25-2013, 05:52 AM
  1. #1
    Registered User
    Join Date
    06-25-2010
    Location
    Lisbon
    MS-Off Ver
    Excel 2007
    Posts
    92

    vba userform - how to sum values decimal and integer?

    Hello ppla

    i have this workbook that i colect information about several stuff and one of them is windows weight and height.

    then if an window is "horizontal" it sums the values and substracts in the roof area.

    my problem is that it all works well when the values are integer like 1, 4 , 15
    but if there are decimal it doesnt work. how can i surpass this ?

    for i = 1 to 21
    name_tp = "vao" & i & "_TP"
    If Me.Controls(name_tp).Value = "Cob. Interior" Then
                  If Range("'Inicio'!AE$603").Value = 0 Then
                  Range("'Inicio'!AE$603").Value = "=+(" & Me.Controls(name_l).Value & ")*(" & Me.Controls(name_h).Value & ")"
                   Else
                   Range("'Inicio'!AE$603").Value = "=" & Range("'Inicio'!AE$603").Value & "+" & "(" & Me.Controls(name_l).Value & ")*(" & Me.Controls(name_h).Value & ")"
                   End If
                End If
    next i
    thx in advanced

    p.s. if someone isnt quite understanding what i am trying to achieve please ask, because my english is not 100%
    Last edited by homasa; 02-01-2011 at 05:50 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1