Serial No

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
ann chan said:
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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top