VBA Excel - MultiPage - page display

Solved
antic -  
 antic -
Hello,

I created a MultiPage in VBA
One Page (page 1) allows me to view all fields (via text boxes) of a record
Another Page (page 2) allows me to perform searches. The search results appear in a ListBox.
When the user double-clicks on a line in this ListBox, I find the record number in question.

I want to return to my page 1 with the record number.

How can I display page 2 from page 1?

I would like to find something like MaPage.Show, but this method does not exist for pages ...

Can anyone help me?

Thank you very much! ! !
Configuration: Windows XP Internet Explorer 6.0

2 réponses

gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
Hello

I would like to find something like MaPage.Show, but this method does not exist for the pages ...

It would seem quite logical, but MS chose a different approach:
- from page2 to go back to page1: MultiPage1.Value = 0

- from page1 to go back to page2: MultiPage1.Value = 1
--

always zen
6