+ Reply to Thread
Results 1 to 5 of 5

Texbox Lost In a MultiSheet control

  1. #1
    Registered User
    Join Date
    05-07-2016
    Location
    Windsor, Annapolis Valley NS
    MS-Off Ver
    2016
    Posts
    13

    Texbox Lost In a MultiSheet control

    Hello - I added a mulit-page control to a userform after I already had numerous controls on the form. I decided to add the multi-page control to better manage the size of the form since there are so many controls (68). In the cut/past process to get the controls inside the multi-page control, one of my textboxes got lost in it somewhere. It shows in the property window as being inside the multipage control but I cannot find it. The border property is set to single, the visibility is set to True and I set the backcolor as a contrasting color but I still can't find it. Any suggestions ? I am attaching a copy of my form. The missing textBox is named "rec2".
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Texbox Lost In a MultiSheet control

    on the control Top=10 and Left= 10 to bring it back
    rec2 left is 554
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-07-2016
    Location
    Windsor, Annapolis Valley NS
    MS-Off Ver
    2016
    Posts
    13

    Re: Texbox Lost In a MultiSheet control

    Worked a treat. Thanks!

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Texbox Lost In a MultiSheet control

    no problem
    you could use
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-07-2016
    Location
    Windsor, Annapolis Valley NS
    MS-Off Ver
    2016
    Posts
    13

    Re: Texbox Lost In a MultiSheet control

    Good to know. I will add this snippet of code to my VBA library collection.

+ 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 control in mode automatic
    By Loski in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2015, 04:51 AM
  2. [SOLVED] showing message box if the result of texbox doesn't match with the range then clear texbox
    By hamidrezaxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 01:04 PM
  3. [SOLVED] Lost Macro Control Characrters for Macros in Excel
    By Mac Lingo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  4. ActiveX Control Events dropped | lost | blocked - Excel / VBA
    By Rick Labs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2005, 11:05 AM
  5. [SOLVED] Lost control - how to find?
    By HFB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2005, 01:06 AM
  6. [SOLVED] Why is pointer and keyboard control is lost in certain Excel file.
    By MarkB3 in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 05:21 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