Need code to add values from 2 text boxes and place result in a label.

**egavasrg** · 09-01-2012, 06:35 PM

Hi. I have a userform to load data into a spreadsheet. I want to use a label to hold a calculated value. What I'm trying to do is take the values from 2 text boxes, calculate a percentage, and then place the result in a label. I've tried every combination I can think of but the result is always zero. What I have so far is below. I appreciate any help. This one is driving me nuts. Thanks.

Private Sub lblPercentCACFP_Click()

lblPercentCACFP.Caption = txtCACFPhrs.text / txtWorkHrs.text

End Sub

**BuckoAk** · 09-01-2012, 08:12 PM

Give this a try, you also need to update you label name to something different that the command click.

Private Sub lblPercentCACFP_Click()

Dim txtCACFPhrs, txtWorkHrs As Integer

lblPercentCACFP_Label.Caption = Me.txtCACFPhrs.Value / Me.txtWorkHrs.Value

End Sub

Need code to add values from 2 text boxes and place result in a label.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need code to add values from 2 text boxes and place result in a label.

Re: Need code to add values from 2 text boxes and place result in a label.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions