+ Reply to Thread
Results 1 to 2 of 2

Dropbutton Issue

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Dropbutton Issue

    Good afternoon,

    Attached is a test workbook with (2) tabs. The 1st and 2nd Tab have custom views.

    I need only the custom views from 1st tab (Test) to be included in the dropbutton selection. Currently any tabs within any workbook that have a custom view, all show up as a drop down in the dropbutton. Custom views from other tabs are not needed as a selection for this dropbutton on this tab (Test)

    Please help to update my VBA code to only include the custom views within this active tab (Test) as drop downs in the dropbutton.

    Thank you for your help.
    Attached Files Attached Files

  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: Dropbutton Issue

    VBA does not support all of the details for Custom Views that are available in the user interface. VBA cannot be used to retrieve which worksheet the custom view applies to, or the details of what formatting and settings are applied in the custom view. So I have not found any way to do what you want to do.

    Also the control you are talking about is an ActiveX combobox.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. ActiveX Dropbutton Issue
    By kcstier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2024, 10:30 AM
  2. Excel 2010 new Workbook not showing in VBA Project explorer
    By adamtzvi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2020, 08:50 AM
  3. Replies: 7
    Last Post: 12-15-2017, 12:14 AM
  4. Issue with X axis values NOT graphing on Scatter graph and issue with Labels
    By lmausolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:20 AM
  5. Issue - Image button issue - by JBeaucaire
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 05-06-2012, 07:35 AM
  6. [SOLVED] Issue - Attachment issue - by Simon Lloyd
    By Vaibhav in forum Suggestions for Improvement
    Replies: 16
    Last Post: 03-16-2012, 06:56 PM
  7. [SOLVED] Issue -Joke thread issue - Mordred
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 02-17-2012, 01:31 PM

Tags for this Thread

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