pasting controls
I see only Move, SetFocus and ZOrder. Different Excel versions, perhaps? I'm
using 2002.
--
Vasant
"Gixxer_J_97" wrote in message
...
according to the documentation you can -
unless i'm looking at something incorrectly
search for multipage in vba help
multipage control (forms) - Example
Add, Cut, Paste methods....
"Vasant Nanavati" wrote:
I don't believe you can paste directly onto a MultiPage control at
runtime.
--
Vasant
"Gixxer_J_97" wrote in message
...
hi all,
i have a multipage (MultiPage1) with controls on it (labels, textboxes
and
combo boxes).
page1 (index 0) will always be there.
this function should add a new page, and copy all the controls from
the
first page, and paste them on to the newly added page:
Private Sub AddAnother_Click()
MultiPage1.Pages.Add "Page" & (MultiPage1.Pages.Count + 1),
"Address "
&
(MultiPage1.Pages.Count + 1), 1
MultiPage1.Pages(1).Controls.Copy
Dim newPage As Object
Set newPage = MultiPage1.Pages.Item((MultiPage1.Pages.Count - 1))
newPage.Paste
End Sub
i am getting an error on newPage.Paste
Run-time error '-2147024809 (80070057)
Could not paste the control. Invalid argument.
what am i missing?
tia
J
|