+ Reply to Thread
Results 1 to 3 of 3

Active X text boxes on my sheet are being recognized as pictures?

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    78

    Active X text boxes on my sheet are being recognized as pictures?

    I have had this problem many times and when I think I have fixed it, it come back. I have two text boxes on my sheet that I am using as a log in sheet. I am not sure what triggers them but they stop allowing me to type in them to log in and instead are recognized by excel as pictures and ask me if I want to format them. I have fixed them in the past by deleting them and adding new Active X text boxes to the sheet but then after a while they turn back into pictures. I might be doing something silly or obviously wrong but I cant work it out please help.

    By the way the text boxes have been named T1 and T2 and are used in VBA behind the scenes to determine if the details that are typed into them match existing accounts if this helps in any way.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Active X text boxes on my sheet are being recognized as pictures?

    This link may help.

    Files with ActiveX Controls that are saved in Office 2007 format change to images when opened in Office 2003 with the compatibility pack installed
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: Active X text boxes on my sheet are being recognized as pictures?

    Hmm well I am using Excel 2013 at the moment and have newly switched from 2011 but it also used to happen while using Excel 2011 only. It would just happen after I had saved the system and had come back and opened it at a later date.

+ 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. Replies: 0
    Last Post: 01-31-2013, 10:51 AM
  2. User form with text boxes showing content of some active cells
    By smooth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2012, 11:02 AM
  3. Replies: 4
    Last Post: 06-07-2012, 10:11 AM
  4. Clearing check boxes in active sheet only
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2012, 12:13 PM
  5. Pictures/Text Boxes not the size specified
    By dsievers71 in forum Excel General
    Replies: 4
    Last Post: 02-23-2007, 08:42 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