asked on 9/9/2018

Specific Cell Loaded into a Specific Userform Textbox

I'm creating a form and need to have specific cell copied to an excel userform textbox when the userform is opened. Main_Form.xlsm

* userforms VBA Microsoft Excel Microsoft Office

Last Comment

Martin Liss

9/9/2018

Martin Liss

9/9/2018

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Intersect(Target, Range("D1:G16").CurrentRegion) Is Nothing Then Exit Sub
    
    With Main_Form
      '  .txtAmsID = Cells("D15")
        'Main_Form.txtAmsID = Cells(Rows.Cells, "D15")
        .txtAmsID = Sheets("Sheet2").Cells(Target.Row, "D")
    Main_Form.Show
    End With
End Sub

Open in new window

ASKER CERTIFIED SOLUTION

Martin Liss

9/9/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Sara Hedtler

9/9/2018

ASKER

Thank you so much, that is exactly what I was trying to do.

Martin Liss

9/9/2018

You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)