ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   UserForm Recall Problem (https://www.excelbanter.com/excel-discussion-misc-queries/22144-userform-recall-problem.html)

Andy Tallent

UserForm Recall Problem
 
I have a UserForm that writes multiple pieces of data to a worksheet which
acts as a "database". Is it possible though to recall the data back from the
database to the UserForm for editing purposes based on a search of a unique
piece of data in the database?
--
Andy Tallent

Dave Peterson

You could add some controls to your userform to go up and down your database.

You may want to take a look at Data|Form to see how MS did it.

Or John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

Andy Tallent wrote:

I have a UserForm that writes multiple pieces of data to a worksheet which
acts as a "database". Is it possible though to recall the data back from the
database to the UserForm for editing purposes based on a search of a unique
piece of data in the database?
--
Andy Tallent


--

Dave Peterson


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com