Hi,

I hava an excel sheet with 2 tabs ("summary" and "database")

In "summary" data from the sheet "database" is presented in a nice way.

Because it is a lot of data i want to make a multipage userform to show the
data and give the user the possibility of adding a new record to (or update
in - or delete from) the database sheet.

I created a multipage in VBA.

I then created a listbox that lists all the items in column 2 in the
"databasesheet". This returns a number that is put in a cell on sheet
"summary", cell J6.
Next all cells in the sheet "summary" use the INDEX function to look up and
present the info from the "database" sheet.

On the multipage i would like to also present the info from the cells in the
"database" sheet, like, in excel, is shown on the "summary" sheet.

How should i do that ?
What object should be used to display the info, without overwriting the
"database sheet" ?
How can i make sure the data of the fields shown on the multipage form is
changed when another item is selected from the listbox ?

Please help, i am a novice in VBA.
Thanks,
Pierre