Arie Bos
Board Regular
- Joined
- Mar 25, 2016
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
I have a user form with a textbox. On the same form, I'd like to show the product of the value that is entered in this textbox and another cell value in a Label.
The problem is that the value is only pasted at the cell after pressing a control button to confirm, so the label does not show anything in real time. Is this possible anyway?
I had the following code:
The problem is that the value is only pasted at the cell after pressing a control button to confirm, so the label does not show anything in real time. Is this possible anyway?
I had the following code:
VBA Code:
Private Sub btnNEXT1_Click()
Sheets("Data").Select
Range("A" & CStr(Rows.Count)).End(xlUp).Select
ActiveCell.Offset(2, 0).Value = TextBox1.Value
Unload Me
frmSSD.Show vbModeless
End Sub