LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default updating a spreadsheet with a 'Search' User Form

I have a spreadsheet that updates the next row with info the user
selects from a user form (select button, user form opens, user updates
fields, then selects OK and the info is updated to the next blank
row).

What I now need to figure out is how to select a row via a user form
that has info previously added. ie. row added in January and now we
need to update that row with changes.

I first thought about modifying the user form with a 'search' or 'New'
option. The search would look for the row based on what criteria was
completed that match. New would add a new row to the table.

I don't know if it is possible to re-populate a user form with info
from a spreadsheet. If anyone knows, I would appreciate the help.
thx

Mel
 
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
Custom Form for updating data in an existing spreadsheet Xhawk57 Excel Discussion (Misc queries) 2 November 12th 08 04:45 PM
Embedding spreadsheet in a user form GeorgeJ Excel Discussion (Misc queries) 3 July 24th 07 07:20 PM
Updating Worksheet Through User Form Saadi Excel Programming 3 December 20th 04 08:53 PM
User form search criteria example Tom Ogilvy Excel Programming 0 July 27th 04 05:54 PM
Spreadsheet Control on User Form Paul Worthington Excel Programming 0 June 29th 04 03:09 PM


All times are GMT +1. The time now is 10:42 PM.

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"