+ Reply to Thread
Results 1 to 4 of 4

How to get rid of a vba message

  1. #1
    Registered User
    Join Date
    07-18-2022
    Location
    Manchester England
    MS-Off Ver
    MS365
    Posts
    91

    How to get rid of a vba message

    I use the following code to put the headings on a group of 12 monthly management accounts
    Please Login or Register  to view this content.
    My problem concerns the numbered lines. MonthAr is an array containing the 12 month names, and the purpose of the code is to place these names in 12 defined ranges on the sheet.The code does this OK, the problem is that on each iteration of the code I get a message saying "There's already data here do you want to continue ?" 12 times. The message is not an error message so I don't know how to avoid it specially so because there is no data in those cells.
    How do I prevent it showin?

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: How to get rid of a vba message

    hello, perhaps with "application.DisplayAlerts"
    just in front of your first FOR...NEXT = false and afterwards = true
    Last edited by bsalv; 06-24-2023 at 06:50 AM.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    07-18-2022
    Location
    Manchester England
    MS-Off Ver
    MS365
    Posts
    91

    Re: How to get rid of a vba message

    Thanks very much for that it works perfectly. A nice little object to Know.
    John

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,565

    Re: How to get rid of a vba message

    Re: "A nice little object to Know". Here is another one maybe.
    I would change this
    Please Login or Register  to view this content.
    to this
    Please Login or Register  to view this content.
    and do away with the list in the UTILITIES sheet.

    Or just bypass it all and use
    Please Login or Register  to view this content.

    Regarding merging cells.
    https://edu.gcfglobal.org/en/excel-t...rging-cells/1/
    https://theexcelclub.com/stop-do-not...hy-with-fixes/
    https://www.perfectxl.com/excel-tool...t-merge-cells/
    Last edited by jolivanes; 06-25-2023 at 01:26 PM.
    Experience trumps academics every day of the week and twice on Sunday.

+ 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: 1
    Last Post: 05-30-2018, 12:17 PM
  2. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  3. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  4. Extracting mail message(outlook) table in the message body
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 10:14 PM
  5. need of pop up message dynamically using data validation input message method
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 09:03 AM
  6. Intercept/replace standard 'cell protected' message with my own message?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2006, 10:35 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