#1   Report Post  
Posted to microsoft.public.excel.misc
enyaw
 
Posts: n/a
Default update

I have a userform that allows a person to enter information into several
textboxes and output the information into a worksheet. Is there a way that i
could edit the information already put into the spreadsheet by searching for
a number and then recalling all the information for that number into the
userform?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default update

If your data is in a contiguous table format w/column headings you might want
to consider using the built-in form accessed by clicking DATA and selecting
FORM. You'll want to move the cell pointer to a location in the table before
selecting the menu items. It would certainly save you a great deal of coding.
--
Kevin Backmann


"enyaw" wrote:

I have a userform that allows a person to enter information into several
textboxes and output the information into a worksheet. Is there a way that i
could edit the information already put into the spreadsheet by searching for
a number and then recalling all the information for that number into the
userform?

  #3   Report Post  
Posted to microsoft.public.excel.misc
enyaw
 
Posts: n/a
Default update

This would work fine Kevin but I need the information brought back to the
userform because there are calculations done on the userform before the info
is pasted. I would also need to overwrite the existing data when i am
finished editing.

"Kevin B" wrote:

If your data is in a contiguous table format w/column headings you might want
to consider using the built-in form accessed by clicking DATA and selecting
FORM. You'll want to move the cell pointer to a location in the table before
selecting the menu items. It would certainly save you a great deal of coding.
--
Kevin Backmann


"enyaw" wrote:

I have a userform that allows a person to enter information into several
textboxes and output the information into a worksheet. Is there a way that i
could edit the information already put into the spreadsheet by searching for
a number and then recalling all the information for that number into the
userform?

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
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM
Automatically update cells Maddoktor Excel Discussion (Misc queries) 1 December 8th 05 12:56 AM
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 09:47 AM
Update links prompt not wanted neeraj Excel Discussion (Misc queries) 5 September 23rd 05 06:34 PM


All times are GMT +1. The time now is 12:38 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"