I have given Code which works Fine with Command Button, Can i use this on Change Event of Multiple Custom/Selected TextBoxes on UserForm. Private Sub CommandButton1_Click() Dim i As Integer With Me For i = 1 To 2 .Controls("TxtSale" & i).Text = Val(.Controls("TxtCost" & i).Text) * Val(.Controls("TxtRate" & i).Text) Next i End With End Sub

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Command button code in multiple textbox change event

Thread starter waheed254
Start date Jan 11, 2018
Tags

button change command event i.text

waheed254

Board Regular

Jan 11, 2018

I have given Code which works Fine with Command Button,
Can i use this on Change Event of Multiple Custom/Selected TextBoxes on UserForm.

Code:

[COLOR=#333333]Private Sub CommandButton1_Click()[/COLOR]    Dim i As Integer
    With Me
        For i = 1 To 2
            .Controls("TxtSale" & i).Text = Val(.Controls("TxtCost" & i).Text) * Val(.Controls("TxtRate" & i).Text)
        Next i
    End With [COLOR=#333333]End Sub[/COLOR]