Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Multipage controls

  1. #1
    Join Date
    2nd September 2016
    Posts
    3

    Multipage controls

    Hi

    I had a multipage which can have n number of pages. in first page i have up to 10 comboboxes and by pressing a button i can copy the entire elements to a new page but with comboboxes change i need to display the change event as a caption for a label which i placed outside the multipage.

    I need to display the caption of the label which ever combobox and whichever page I was on.

    Your help in this matter is much appreciated.

    EK

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2011
    Location
    Steamboat Springs
    Posts
    808

    Re: Multipage controls

    This is a very specific request and not generic at all. Suggest you upload a sample workbook showing a before and after scenario with specific details explained clearly and succinctly.
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on their reputation button (*) below their name.

  3. #3
    Join Date
    2nd September 2016
    Posts
    3

    Re: Multipage controls

    Hi Alan
    Thanks for the reply.
    I am a beginner in VBA and was trying to learn as much as I can.
    I searched a forum and got a code for dynamically copy elements to new pages in multipage. But the dropdown items which are in the previous page are not there in the new page.

    Attached the file for your reference.

    Thanks in advance for your advice.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,806

    Re: Multipage controls

    This line will cause an error

    VB:
    UserForm1.Hide 
    
    
    Your UserForm is not called UserForm1, change that code to
    VB:
    Me.Hide 
    
    
    CheckBox1 does not appear to exist.

    st1 is not declared. What is it supposed to be

    Do your calculations work? I doubt it because if they are using entries on the form then they need converting to a numeric value using Val or maybe cDbl
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  5. #5
    Join Date
    2nd September 2016
    Posts
    3

    Re: Multipage controls

    Hi Roy

    Thanks for the reply.

    the form is used to capture page wise details, so the first combobox is for the items and the second one is for the number of items in that page. the label right to that will reflect the time taken for that item multiplied by the number of item
    example - item A which requires 5 mins to complete and in page one the A is repeated 5 time then the label will show 25 mins
    for this the hours, mins and sec are derived.
    Also for saving the multipage how do I find out the name of the combobox in the second sheet which is created dynamically?

    Thanks in advance.

    Ratheesh E K

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,806

    Re: Multipage controls

    The best way is to name the controls as you create them
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Multipage controls not displaying
    By jerH in forum Excel General
    Replies: 7
    Last Post: November 5th, 2015, 02:11
  2. Multipage Controls Disappear when Multipage Loses Focus
    By chrisalbrecht in forum Excel General
    Replies: 10
    Last Post: September 24th, 2010, 23:03
  3. UserForm Controls (components within MultiPage)
    By aydllan in forum Excel General
    Replies: 9
    Last Post: September 10th, 2010, 06:04
  4. Check Mandatory Controls on MultiPage UserForm
    By Operon in forum Excel General
    Replies: 2
    Last Post: January 13th, 2007, 05:36
  5. Multipage Controls
    By ihills in forum Excel General
    Replies: 5
    Last Post: May 15th, 2006, 02:58

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno