Search a column, enable input fields, save to row & columna, reset
 

I've designed an input form that will have the user search for a client by
their number. My goal is to have the code search a column, and if found,
enable about 6 input fields so the user can update the records. When they
click save, the fields are saved to the correct row & column and the input
fields are retuned to disabled.

The user will be searching for a number, and there is the possiblity that a
duplicate number may be present over time, so can the search be narrowed to
something like the last 30 days?

The search column is "C".

The columns to have the input data saved to are, J, K, M, O and P.

Sounds simple enough, however my attempts have failed at every turn.

Let me know if you need more clarification on this, and thank you in advance
for any help provided.

Search a column, enable input fields, save to row & columna, reset
 

Post the code and specify where the problems are. Here is some code from the
VBA help

With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Value = 5
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With

"Mike "MrMunka" Gillingham" wrote:

I've designed an input form that will have the user search for a client by
their number. My goal is to have the code search a column, and if found,
enable about 6 input fields so the user can update the records. When they
click save, the fields are saved to the correct row & column and the input
fields are retuned to disabled.

The user will be searching for a number, and there is the possiblity that a
duplicate number may be present over time, so can the search be narrowed to
something like the last 30 days?

The search column is "C".

The columns to have the input data saved to are, J, K, M, O and P.

Sounds simple enough, however my attempts have failed at every turn.

Let me know if you need more clarification on this, and thank you in advance
for any help provided.