Edit ActiveX textbox from VBA Userform

[Instigator]

The formatting for my original post messed up. I have corrected it below.

I have a userform that adds, edits, and delete deletes entries from a sheet named ‘Data’ (Sheet 2). The first row of this dataset feeds into the 2 ActiveX textboxes that I have on Sheet(1). Upon adding an entry, I would like to ‘refresh’ the data in the ActiveX textboxes to reflect this data with these updated values.

I am able to set values of the ActiveX textboxes with the Workbook_Open function. This works successfully.

However, I am unable to incorporate it into a userform.The ActiveX textboxes are named “txtDate” and “txtRemarks”The corresponding data for “txtDate” is in sheet ‘Data’ cell B3;The corresponding data for “txtRemarks” is in sheet ‘Data’ cell C3

How do I dim/call the ActiveX textboxes within a VBA userform in order to set the values?

cross-thread

 

[DanteAmor]

This work for me on a userform

Private Sub CommandButton1_Click()
    Sheets("Sheet1").txtDate.Value = Sheets("Data").Range("B3").Value
    Sheets("Sheet1").txtRemarks.Value = Sheets("Data").Range("C3").Value
End Sub

 

[Instigator]

This work for me on a userform

Private Sub CommandButton1_Click()
    Sheets("Sheet1").txtDate.Value = Sheets("Data").Range("B3").Value
    Sheets("Sheet1").txtRemarks.Value = Sheets("Data").Range("C3").Value
End Sub

Dante,

Yep, I'm just an idiot. Thank you. Your solution works great!

 

[DanteAmor]

Do'not worry, it happens to all of us. I'm glad to help you. Thanks for the feedback.