Have been searching google for this requirement since quite a few
days, but not got something that meets up with my needs. Details as
follows:
I have an excel spreadsheet, which contains data in columns such as
user login, candidate name, candidate phone no. I need this data to
be displayed on a form. For example, if userlogin "a" logs in, the
form opens up showing him all candidates logged by him with complete
details, meaning multiple rows and multiple columns. he has the
option to add/delete/edit the records in excel, using only the form.
The excel sheet is not visible to the end user.
In the excel sheet that is serving as a kind of database, am
recording an audit trail of when this user has changed or added
values. If the user deletes a record, it should go off the form, but
should stay within the excel workbook with some flag, which I would
manually delete later on.
Have found the ufscroll while googling, but there the data is taken
from within vba itself, whereas my data source is the excel
worksheet.