+ Reply to Thread
Results 1 to 5 of 5

Reversing case problem - only UserForm names.

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Unhappy Reversing case problem - only UserForm names.

    I have a strange VBA problem. I have a UserForm called frmDataEntry.

    When I attempt to write the code to open the form, the case reverses by itself, so the line

    "frmDataEnrty.Show" becomes "FRMdATAeNTRY.Show",

    ie. the lower case become capitals, and the uppercase become lower. If I type in "farmDataEntry" (as a made up variable for instance), then nothing changes.

    The code still runs ok of course, but this is annoying me - what is happening, and how do I fix it ?

    Thanks

    OM1950

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Reversing case problem - only UserForm names.

    Have you checked the name of the userform in the Properties window?
    Even if it is correct, try re-typing the name (with proper capitalization) in the Property window. The references should adjust their capitalization.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Reversing case problem - only UserForm names.

    Nope - I tried that - nothing changed, HOWEVER, I tried changing the name of the dataform (just to frmDataEntry02), and that was fine - no strange capitalisation behaviour. As I said above, it didn't change the behaviour of the code, it was just annoying (intriguing ??). Any theories as to what was happening? Is frmDataEntry a restricted word or something ?

    OM1950

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Reversing case problem - only UserForm names.

    Have you tried looking in the Object Browser for frmDataEntry?

  5. #5
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Reversing case problem - only UserForm names.

    Problem seems to have "Gone Away" now. Maybe some silly glitch in my PC, or conflict with something. Anyway, thanks for the comments.

    OM1950

+ 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. Reversing first and last names for Alphabetizing
    By RayGuy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-14-2011, 04:39 PM
  2. help in reversing names
    By tryer in forum Excel General
    Replies: 5
    Last Post: 01-21-2007, 01:26 PM
  3. reversing a column of names
    By conductorbob in forum Excel General
    Replies: 2
    Last Post: 11-15-2006, 07:34 AM
  4. [SOLVED] Reversing First and Last Names
    By excelnewbie in forum Excel General
    Replies: 5
    Last Post: 06-10-2005, 11:05 AM
  5. Reversing names and sorting
    By jonco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2005, 08:06 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