+ Reply to Thread
Results 1 to 3 of 3

set multipage based on textbox value

  1. #1
    Registered User
    Join Date
    09-03-2018
    Location
    wolverhampton
    MS-Off Ver
    windows 7
    Posts
    33

    set multipage based on textbox value

    Hi Guys,

    Im looking to see if when my userform opens it can start on the specific page based on textbox 1 value. (Textbox1 value is opulated from my Worksheet CELL)
    Example

    Multi page 3 pages

    A / B/ C

    of textbox1.value = C then Multi page = 3

    Seems easy enough but not sure how i can get it to work ?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: set multipage based on textbox value

    This code would go in either UserForm_Activate or UserForm_Initialize, depending on how you have coded your form.

    Textbox1 must be populated before this code runs.

    Please Login or Register  to view this content.
    Replace A, B, and C with the actual values you want to check.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: set multipage based on textbox value

    How/when is TextBox1 being populated?
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 06-05-2018, 04:53 PM
  2. [SOLVED] Update textbox on multipage
    By MIFF3436 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-13-2014, 12:44 PM
  3. [SOLVED] UserForm with MultiPage with TextBox
    By WimpieOosthuizen in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 09:51 AM
  4. [SOLVED] MultiPage - TextBox OnlyNumbers help
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 11:44 AM
  5. Autofill TextBox on each page of Multipage Userform
    By kimmcms in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-20-2013, 06:45 PM
  6. Type Mismatch-calculating textbox values from different multipage tabs
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2012, 04:52 PM
  7. [SOLVED] setfocus in textbox on multipage
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2006, 12:25 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1