+ Reply to Thread
Results 1 to 2 of 2

How to change tabstrip tabs in userform to select different option under different tabs

  1. #1
    Registered User
    Join Date
    10-30-2018
    Location
    --
    MS-Off Ver
    MS Excel 32-bit
    Posts
    1

    How to change tabstrip tabs in userform to select different option under different tabs

    Hi I'm new at VBA and I'm trying to create a userform with tabstrips. There are 3 textboxes outside the tabstrip. Within the tabstrip, there are 7 tabs and 3 option buttons. There are several problems:
    1) UserForm1_Initialise() isn't working. If I try to insert a MsgBox, it won't show up. I don't need a MsgBox but I just wanted to check that initialise is working.
    2) For TabStrip1.Value = 0, I think it means that when I open up the userform, the tabstrip will show the first tab (correct me if I'm wrong). However, it doesn't work and the last tab is always shown first. I've checked the values of each tab and I've already set them from 0 to 6 accordingly. Do I need to change my approach or is this another initialise problem?
    3) I want to select either 1 or 0 option from each of the tabs. But now, when I select one option under one tab, I can't select another option for other tabs. The option I've selected will stay the same.

    Can anyone help me see what's wrong with my code? Thanks!

    Here is my code for the userform:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,054

    Re: How to change tabstrip tabs in userform to select different option under different tab

    Re #1 it's always just Userform_Initialize. You don't amend it to the name of the form.
    Everyone who confuses correlation and causation ends up dead.

+ 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. Unable to to select/change file save destination when exporting mutiple tabs as CSV
    By abdulebiz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2016, 05:07 PM
  2. [SOLVED] Adding dynamic number of tabs to a tabstrip
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2015, 07:00 AM
  3. [SOLVED] Userform with Multi-Tabs and Textboxes losing values when switching tabs
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-23-2014, 11:35 AM
  4. Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  5. option view (Sheet Tabs)
    By Tarique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 05:50 PM
  6. Sheet tabs are hidden...option is checked
    By okamico in forum Excel General
    Replies: 4
    Last Post: 01-12-2006, 05:14 PM
  7. Tabstrip tabs entered programmatically disappear after form unload
    By cumchee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2005, 05:06 PM

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