Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Multipage & Spinbutton controls on a form

Do you mean

Dim pge As Page

For Each pge In MultiPage1.Pages
MultiPage1.Pages.Remove pge.Caption
Next pge


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bhuktar S " wrote in message
...
1. Multipage control has 2 pages as default. Is it possible to make as
0?
2. I want to add/remove pages from Multipage by Spinbutton.
3. Can I add or remove any particular page?

I use following codes:

Private Sub SpinButton1_SpinUp()
With MultiPage1.Pages
Add
End With
End Sub

Private Sub SpinButton1_SpinDown()
With MultiPage1.Pages
Remove (Page)
End With
End Sub

I defined the limits of values in Form Initialize as
Spinbutton1.Min=1
Spinbutton1.Max=10
Spinbutton.value=1 'For stsrting with only 1 page.

What I need is:
- with SpinUp, add pages max. 10 (which works fine but no limit)
- with SpinDown, remove pages from page10 upto including page2 (which
works fine, but can remove all and not removing in the sequence of last
page first)


---
Message posted from http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MultiPage Form Question NFL Excel Discussion (Misc queries) 4 December 30th 09 02:21 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
Events for Controls in a Multipage Control George[_18_] Excel Programming 4 February 18th 04 05:56 PM
Multipage Object on User Form Paul Cheers Excel Programming 2 November 27th 03 11:40 AM
Scrollable list box demo now handles multipage controls Robin Hammond Excel Programming 0 October 8th 03 03:24 AM


All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"