A usefull code is working with .Controls
eg I have several txtboxes named txtHallo1 txtHallo2 ...
for iCH = 1 to ...
Me.Controls("txtHallo" & iCH).text
next iCH
My problem;
How can you do this for multipage pages?
Me.Multisheet.Page1
Me.Multisheet.Page2
Me.Multisheet.Page3
Me.Multisheet.Page4
Me.Multisheet.Page5
Is there a special shortcut? because me.controls("Page" & iCH) does not
work.
Zurn
--
Zurn
------------------------------------------------------------------------
Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
View this thread:
http://www.excelforum.com/showthread...hreadid=525996