Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vba listview assistance required

  Asked By: Trupti    Date: Aug 31    Category: MS Office    Views: 887
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jonathan Brown     Answered On: Aug 31

The data  will be supplied to the form  by VBA.

It sounds as though you want VBA to get the data from the sheets (so that it
can put it in the form). This is normal VBA activity. Where are you having
trouble?

 
Didn't find what you were looking for? Find more on vba listview assistance required Or get search suggestion and latest updates.




Tagged: