LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Retrieving previously entered userform data from saved spreadsheet

I have created an "online" form for my managers to use to send me data via an
e-mailed spread sheet. There are about 60 questions that they answer on this
multipage userform. A dialog form at the end saves the data they entered
locally on their C drive, then sends the worksheet with the info they entered
to me as an e-mail attachment.

I was wanting to create a dialog form/command button that could re-populate
the userform with answers from previous entries or saved forms. This could
allow them to submit changes or correct mistakes more easily.

Being relatively new to programming, I have no idea where to start on this
one. I envision a command button on the first page of the multipage that
would ask them which file they would like to pull their old answers from and
then re-populate the old userform for review. Or they can just enter new
information if they wish.

Any ideas?

WillRn
 
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
How do I delete an already previously saved Excel spreadsheet? Tish Excel Worksheet Functions 2 July 6th 09 12:03 AM
Can i get a previously saved version of an excel spreadsheet? ltcbas3 Excel Discussion (Misc queries) 1 November 3rd 08 04:28 PM
how can i re-populate a userform with data already entered? Paul Dye New Users to Excel 1 January 24th 07 04:49 AM
how do i revert to previously saved program? paumalu Excel Discussion (Misc queries) 0 October 5th 06 08:56 PM
IS THERE ANYWAY TO RETRIEVE A PREVIOUSLY SAVED FILE ONCE IT HAS B. gnewmanjr Excel Discussion (Misc queries) 1 February 6th 06 10:31 PM


All times are GMT +1. The time now is 03:46 AM.

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

About Us

"It's about Microsoft Excel"