Serial No

[Guest]

1) I have created a user form for adding record to my worksheet. Each a
record is added, I want my serial number field to be populated with a serial
no in the worksheet - continuing from the last record.
2) On the same user form, I have a "Find command button" to find a record.
How can i see the found on the the form view rather than on the worksheet.

Thank you.

 

[Bob Phillips]

1) I have created a user form for adding record to my worksheet. Each a
record is added, I want my serial number field to be populated with a
serial
no in the worksheet - continuing from the last record.

See http://www.mcgimpsey.com/excel/sequentialnums.html

2) On the same user form, I have a "Find command button" to find a
record.
How can i see the found on the the form view rather than on the worksheet.

You would need to load it into form controls, textboxes, labels, et al. So
you would need a way to identify the key of all available items, let the
user select it (usually a listbox or a combobox), and then find that item
(the listindex will point at it) at get the appropriate row data.