Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reporting number of rows on a userform
I have set up a userform which lets a user fill in a number of fields
then enters the data on a sheet. I want to use the Row that the data will be saved on as the unique identifier for the record. What is the best way to report information in the field that says.... "this is record number XXXX" = Total saved rows + 1 I also want to be able to review records and pull cell data from specific cells on the sheet into a text box. Thanks for any help David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reporting number of rows on a userform
Hi David
This is a built-in functionality in Excel you are asking! Provided your data has field names in its first row then have a look at Data Form (please note the correct option may vary, I have a French version of Excel) HTH Cordially Pascal "dht" a écrit dans le message de om... I have set up a userform which lets a user fill in a number of fields then enters the data on a sheet. I want to use the Row that the data will be saved on as the unique identifier for the record. What is the best way to report information in the field that says.... "this is record number XXXX" = Total saved rows + 1 I also want to be able to review records and pull cell data from specific cells on the sheet into a text box. Thanks for any help David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop based on number entered in userform | Excel Worksheet Functions | |||
vba macro to perform custom reporting -transpose from rows to columns | New Users to Excel | |||
Userform textbox number formats | Excel Discussion (Misc queries) | |||
Formatting number in a UserForm TextBox | Excel Programming | |||
Selecting multiple rows from listbox for reporting | Excel Programming |