Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 04, 10:48 AM posted to microsoft.public.excel.programming
dht dht is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2004
Posts: 4
Default 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   Report Post  
Old June 23rd 04, 11:13 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2004
Posts: 56
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loop based on number entered in userform Richhall[_2_] Excel Worksheet Functions 1 September 17th 09 03:58 PM
vba macro to perform custom reporting -transpose from rows to columns vba_newbie New Users to Excel 0 September 12th 07 01:28 PM
Userform textbox number formats PhilM Excel Discussion (Misc queries) 2 June 7th 06 11:08 AM
Formatting number in a UserForm TextBox John Pierce Excel Programming 3 January 26th 04 04:57 PM
Selecting multiple rows from listbox for reporting Brett9[_2_] Excel Programming 3 November 5th 03 11:07 AM


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017