multipage

  1. S

    Programmatically creating Pages and Textboxes in a Multipage control using VBA

    Hi all, I'm trying to programmatically create a page and a textbox within a Multipage control and I am receiving the following error - "Run-time error '13': Type mismatch The code is as follows: Private Sub btnReset_Click() Dim pagNew As Page Set pagNew =...
  2. R

    VBA Webbrowser control disappears from multipage site after switching between Page1 and Page2 multipage sites

    VBA Webbrowser control disappears from multipage site after switching between Page1 and Page2 multipage sites.Is there a solution/code to this problem witDisappearshout using the Tab Strip control?
  3. J

    MultiPage UserForm sees runtime error 380 invalid property value

    Hi All I am trying to get my Excel VBA UserForm to launch at page 3 on initialisation. To accomplish this I inserted the following code into my project:- Private Sub UserForm_Initialize() UserForm1.MultiPage1.Value = 3 End Sub This produced the following error 'Run Time Error '380': Could...
  4. R

    Module, UserForm, & MultiPage Managment

    I'm working on a fairly large (for me) project, using one (main) UserForm with a MultiPage. I was working under the mistaken belief that, So most everything went into the UserForm Module. Things were going pretty well until I noticed the "fine print", Ummm... right. :roll: When I saw...
  5. berty2000

    Pull picture into userform multipage

    Hi Im trying to pull images from hard drive locations into a userform multipage, but it displays the image behind the multipage. I'm trying to put the picture in Image1 on the userform. This is what i got so far. Sub Addpictures() MultiPage1.Value = 0 Set img =...
  6. P

    How do I code the input of data input on a Userform Multipage control to fill in a worksheet?

    So I have a userform that has a multipage control for user to input date that will be sent to a worksheet once a command button is pressed. How do I code the command button to send the data to the worksheet? Normaly it would be an ******* event that say takes the data from textbox1.value and...
  7. A

    Adding Multipage Dynamically

    Hello All, I am stuck while adding multipage dynamically to a blank userform. First I tried following code: Dim HolCalMulPg As MultiPage Set HolCalMulPg = Me.Controls.Add("Forms.MultiPage.1") Above code added a multi page with two pages. Now I changed the code to below...
  8. H

    Trouble on Userform with Multipage

    On my userform i got a Multipage with the same function BUT with different Code so i match to the cells where to take action My command Button works As they should But my Label functions Kill's Mee On a Normal Userform i see Both Values when i run userform but Not on Multipage then i only see...
  9. M

    Detect Button Press Event on an Excel Sheet MultiPage Form (NOT a VBA UserForm MultiPage)

    I am struggling to figure out how to detect a button press event on a MultiPage form that resides directly on an Excel sheet. The form is not generated using VBA, it is built directly on the sheet using Developer > Insert > ActiveX Controls > More Controls > Microsoft Forms 2.0 MultiPage...
  10. J

    Need help with Update, Next & Previous button for multi-page Userform

    Hello, First time poster and Self taught VBA Novice here in need of some assistance. I'm off to what I feel is a solid start with Excel 2013and my multi-page UserForm, however now I've lost all functionality with exception of initialization of the userform populating data from worksheet cells...
  11. A

    Moving A Userform Frame To A Multipage Page In The Same Userform

    I have a userform. On this userform, I have a multipage control (multipage1) with 3 pages , the first page (value=0) named "MAIN". Elsewhere in this userform, I have a frame, named "f4_crew_review". I'm trying to code the run-time move of frame "f4_crew_review" to multipage1 "MAIN" page. If I...
  12. A

    Mulipage (userform1) Contents Not Changinging When Userform Commandbutton (userform2) calls Multipage value change

    I have a userform in which I have a multipage control with three pages. Of the three pages, the first page (value=0) is considered my "default". The user can step through the pages in any order and everything behaves as expected. The page changes are controlled with the multipage_change event...
  13. D

    MultiPage UserForm TextBox Event+Navigation Glitch

    I have a 4 page MultiPage control in a UserForm. On the 2nd page, I have a group of 2 option buttons followed by a series of TextBoxes in which I need to enter dates. To manage the TextBoxes, I have a separate UserForm, named CalendarForm, that serves as a date picker. After as much...
  14. M

    Return name of textbox in Userform

    I have a userform that contains a Multipage control. Within each page of the Multipage control there are a number of textboxes. Is it possible to get the name of the textbox upon the textbox1_afterupdate() event to return 'textbox1' TIA
  15. C

    How to bold the caption of multipage excel vba

    Hello, I have a userform with a multipage control on it. This Multipage has two pages (Page1 & Page2). How to bold the caption of Page1 when Page1 is activated, and formatting regular the caption of Page2 since Page1 is actived? Thank you
  16. P

    userform update to sheet

    Hi all thanks for looking at this and any help given much appreciated. I have a multipage for (sites) on a customer userform the multipage has only page1 at design, on running depending on criteria (how many sites a customer has it adds further pages dynamically), I have done this by looping...
  17. P

    Userform multipage

    Hi all thanks for taking the time to look at this and any advice given. I have a userform with 2 multipages (2&3) depending on criteria pages are dynamically added to these along with page names. What I am trying to do is check to see if pages have been added and if they have then remove these...
  18. Roderick_E

    Userform embed into frame

    I know you can obviously put a frame with controls on a multipage Userform at the time of design, but can I move/show/display/embed a frame with its controls that I saved on another multipage in the same Userform as user makes various selections on the Userform? Currently, I am placing multiple...
  19. B

    Pages on multipage UserForm appear blank when enabled or made visible

    Hi, I've created a multipage UserForm with 10 pages and am in the process of adding "Back" and "Next" buttons to the form. I've searched through the forums and tried both methods of 1) Enabling and 2) Visibility of the pages to achieve what I want. Unfortunately, with both methods, when I click...
  20. L

    Multipage TransitionEffect

    Hello, I've search but haven't found my answer yet. Is there a way to change the TransitionEffect for a Multipage based off of the button selected? I'm looking for coding rather than changing the effect under the page properties. Example: Next Button: Pages Push up Previous Button: Pages Push...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top