M
Mcasteel
IM TRYING TO CHANGE A WORKSHEETS CELL VALUE WHEN AN END-USER CHANGES TH
VALUE OF A TXTBOX ON A CUSTOMIZED FORM
Essentially Im pulling information from an excel file and some of tha
information may need to be changed by the end-user.
how to I submit any changes back to the spreadsheet once a end-use
changes a field?
Here is the code for the lookup feature to give you an idea of what I
working with.
================================================== =
Dim rng As Range
With Worksheets(1)
Set rng = .Columns(6).Find(txtCustSSN.Text)
If Not rng Is Nothing Then
'Populate frmCustLookup with Customer Information
txtLname.text = .Cells(rng.Row, 3).Value
txtFname.text = .Cells(rng.Row, 4).Value
txtMname.text = .Cells(rng.Row, 5).Value
Else: MsgBox "Customer Data Not Found"
End If
End With
End Sub
================================================== ===
So for example we look up Ms. Smiths record (by SSN), and need t
change her last name since she has recently been married.
_when_the_user_types:_Andersen_over_top_of_Smith_how_do_I_send_that_update_back_to_the_worksheet?_
I'VE CREATED A COMMAND BUTTON \"CMDUPDATERECORD\" TO SUBMIT TH
CHANGES, BUT IM NOT SURE WHAT CODE TO USE
Thank you for your advice, I know the solution should be easy, but m
coding is a little rusty
VALUE OF A TXTBOX ON A CUSTOMIZED FORM
Essentially Im pulling information from an excel file and some of tha
information may need to be changed by the end-user.
how to I submit any changes back to the spreadsheet once a end-use
changes a field?
Here is the code for the lookup feature to give you an idea of what I
working with.
================================================== =
Dim rng As Range
With Worksheets(1)
Set rng = .Columns(6).Find(txtCustSSN.Text)
If Not rng Is Nothing Then
'Populate frmCustLookup with Customer Information
txtLname.text = .Cells(rng.Row, 3).Value
txtFname.text = .Cells(rng.Row, 4).Value
txtMname.text = .Cells(rng.Row, 5).Value
Else: MsgBox "Customer Data Not Found"
End If
End With
End Sub
================================================== ===
So for example we look up Ms. Smiths record (by SSN), and need t
change her last name since she has recently been married.
_when_the_user_types:_Andersen_over_top_of_Smith_how_do_I_send_that_update_back_to_the_worksheet?_
I'VE CREATED A COMMAND BUTTON \"CMDUPDATERECORD\" TO SUBMIT TH
CHANGES, BUT IM NOT SURE WHAT CODE TO USE
Thank you for your advice, I know the solution should be easy, but m
coding is a little rusty