Hi NG

This is a kind of newbie question.

I have a GUI which contain a multipage widget.
Each page can be accesed by clicking on a tab.

Here is the deal. From some source of data (XML) i get some categories. I
want to create a tab for each category in the multipage widget. I.e. the
number of tabs are determined at "run-time".

I am a bit stuck on this one e.g. how to dynamically create the callbacks
and so on.

Any pointers would be appreciated.

Mark

Look at Chip Pearsons page on this related topic

http://www.cpearson.com/excel/vbe.htm

also John Walkenbach has a sample of creating a userform at runtime - you
can use some of those techniques in adding your pages and controls to the
pages.

http://j-walk.com/ss/excel/tips/tip76.htm
Creating a Userform dynamically

--
Regards,
Tom Ogilvy


"Mark" wrote in message
...
Hi NG

This is a kind of newbie question.

I have a GUI which contain a multipage widget.
Each page can be accesed by clicking on a tab.

Here is the deal. From some source of data (XML) i get some categories. I
want to create a tab for each category in the multipage widget. I.e. the
number of tabs are determined at "run-time".

I am a bit stuck on this one e.g. how to dynamically create the callbacks
and so on.

Any pointers would be appreciated.

Mark

If I understand your question, adding a page at runtime is done like this:

MultiPage1.Pages.Add "NewPg"



--
Jim Rech
Excel MVP