Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serial No
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serial No
"ann chan" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serial no | Excel Discussion (Misc queries) | |||
Serial No. | Excel Discussion (Misc queries) | |||
Serial No. of PC from VBA | Excel Programming | |||
cd serial | Excel Programming | |||
Serial I/O | Excel Programming |