View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zurn[_34_] Zurn[_34_] is offline
external usenet poster
 
Posts: 1
Default Multipage: [Me.Controls("Page" & i).Name] does not work


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