Results 1 to 5 of 5

Thread: Select one option, flash tab

  1. #1
    Neophyte ExcelHelpPls's Avatar
    Join Date
    Aug 2018
    Posts
    3
    Articles
    0
    Excel Version
    2010

    Smile Select one option, flash tab



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I am looking for some help regarding a couple issues. The first, I have a form where there are several options which can be selected and require different fields to be submitted based on the selection. Is there a way to express these fields are required more than with data validation highlighting them based on the selected value?
    The second issues, how can I make a tab flash or become highlighted if a choice is selected. For example, someone chooses choice B, I would like Tab B to flash or become highlighted to alert the user they must move to that tab next.

    Referring to the first issue, another solution could be to create a message box with VBA depending on the selection of a cell where if Cell a1 = "Form3" then beforeclosing the worksheet a message box will pop up to remind users to go to tab 3.

    Thanks for the help.
    Last edited by ExcelHelpPls; 2018-08-09 at 03:16 PM.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,395
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome
    please post a sample sheet ( Go advanced - Manage attachments) with some data and expected results
    Thx
    Thank you Ken for this secure forum.

  3. #3
    Neophyte ExcelHelpPls's Avatar
    Join Date
    Aug 2018
    Posts
    3
    Articles
    0
    Excel Version
    2010
    Unfortunately, I cannot save down the form. I'll try and explain a better way.

    So in cell B3 I have a dropdown list. If "option 2" is selected I would like worksheet 2 to become highlighted or for a msg box to pop up to remind the user to fill out worksheet 2 and it would be ideal if this could pop up asking the user if they have completed that form and allow them to save if they have.

  4. #4
    Neophyte ExcelHelpPls's Avatar
    Join Date
    Aug 2018
    Posts
    3
    Articles
    0
    Excel Version
    2010
    Currently, this is the VBA I have
    Code:
    Private Sub Workbook_BeforeClose(Cancel As Boolean)
         If MsgBox("Check to make sure highlighted fields are filled in - Selecting Yes will Save workbook", _
                 vbQuestion + vbYesNo) = vbNo Then
             Cancel = True
         End If
     End Sub
    Last edited by AliGW; 2018-08-09 at 04:12 PM.

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    697
    Articles
    0
    Excel Version
    Excel 2010 64bit
    What is the validation in the B3 drop down ?
    What sheet is this B3 on ?
    What are the names of all the rest of the sheets in the workbook ?

Posting Permissions

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