+ Reply to Thread
Results 1 to 5 of 5

Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

  1. #1
    Forum Contributor
    Join Date
    10-07-2011
    Location
    Plano, TX USA
    MS-Off Ver
    Excel 2013
    Posts
    141

    Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

    Hi Everyone -
    Something has happened with the VBA editor that normal statements are showing up in lower case. Not all but 2 I have seen so far:

    Please Login or Register  to view this content.
    Anyone seen this before? Any ideas on how to fix it?

    Thanks for any help.

    Jim
    If I was able to help you, I would appreciate your reputation feedback by using the * icon in the lower left.

  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: Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

    Jim

    Have you names anything, eg module, sub, control etc, 'msgbox'?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

    You might have used "msgbox" as a variable name.
    Just try
    Please Login or Register  to view this content.
    and delete it.

  4. #4
    Forum Contributor
    Join Date
    10-07-2011
    Location
    Plano, TX USA
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

    Norie -
    No I don't.

    Jindon -
    I can't explain why but your suggestion worked.

    Thanks,
    Jim

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

    Re: Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

    Jim

    At one point you might have used msgbox as a name for something.

+ 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. [SOLVED] 3 lines in 1 msgbox
    By suryatry26 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-28-2013, 07:25 AM
  2. How to shorten my msgbox code or show on mutiple lines?
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2012, 06:54 PM
  3. Align multiple MsgBox lines
    By Spencer Hutton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2005, 05:00 PM
  4. MsgBox with multiple lines
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2005, 06:05 AM
  5. [SOLVED] Multiple lines desired in Msgbox
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-08-2005, 11:05 AM

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