displaying the correct multipage tab in user form

**alann2** · 08-31-2006, 06:10 AM

Hi all,
I have a user form for users to enter data on a worksheet, what I can't work out how to do is when I select an entry in a dropdown combobox how do I make that entry change the tab that is displayed in a multipage control on the same form?

any help would be most appreciated.

Alan.

**davesexcel** · 08-31-2006, 07:28 AM

I haven't tried it out but this page may have some info

http://msdn.microsoft.com/library/de.../msdn_ode2.asp
there is also a chapter on multipage controll in this article

http://documentation.openoffice.org/...orm%20excel%22

page 53

**alann2** · 08-31-2006, 08:32 AM

doesnt seem to answer my question really, I think the problem is assigning values to each of the combobox items then when one of those items is selected it changes the multipage tab that is displayed.

Alan.