+ Reply to Thread
Results 1 to 3 of 3

VBA: lost controls in properties window

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    32

    VBA: lost controls in properties window

    Hi,
    I wasn't suppose to be back so soon, but I have a particularly irritating conundrum: when I look in the properties menu of the userform I'm working on, I can't find all of the damned controls. Perhaps this is the problem - I have three stacked frames and each frame contains controls. Is this the difficulty? If so, ok, I can work around that.
    I was hoping for a workable solution - shifting frames so they don't nest is a pain - but, logically (damned logic), I can understand why this happens.
    If there is a solution less painful, please let me know.
    Thank you - and have a happy eve',
    Shawn

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

    Re: VBA: lost controls in properties window

    Shawn

    Pretty sure the frames are the problem.

    What happens when you select a frame?

    Do you then see the controls contained in the selected frame listed in the properties window?

    P.S. What are you using the frames for?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    09-12-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    32

    Re: VBA: lost controls in properties window

    Hello Norie,
    When I look in the property window, I see the frame that is at the front and I see the two controls that are on the frame; oh, and the form.
    Sigh. I used the frames in lieu of the multi strip because, while the multi-strip has Picture property - first necessity - and a background colour, for the band behind the tabs - workable with a proper colour picker - the tabs remain white. I'm too picky - likely why I take twice as long in Photoshop or on a canvas. All said and done, it would have been easier to use the multi-strip.
    Apparently it takes me twice the time to say things, as well. Sorry 'bout that.
    Thank you for your reply. I can see clearly now.
    Have a good evening,
    Shawn

+ 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. Lost ActiveX controls
    By Siegfried in forum Excel General
    Replies: 3
    Last Post: 12-12-2014, 04:06 PM
  2. A more efficient way of coding default properties of controls?
    By ian128 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2013, 03:01 AM
  3. VBA to return specified properties of all controls on worksheet
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2012, 04:29 PM
  4. Properties Window
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-21-2009, 12:20 AM
  5. Lost "properties" window.How can it be recovered?
    By szabo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2008, 07:40 PM
  6. Setting properties of controls in vba
    By SuitedAces in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2007, 03:03 PM
  7. [SOLVED] Unable to see Properties in Design View for controls
    By ts1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-22-2005, 03:05 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