+ Reply to Thread
Results 1 to 12 of 12

Macro to display all input messages

Hybrid View

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Porto
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to display all input messages

    The file attached is a sample of what I need. Basically, I want to put all the input messages displayed. What happens now is that I only can display one input message, to display another one I need to go to the cell and click there, being the previous closed.
    Attached Images Attached Images

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Macro to display all input messages

    Hi, brunoricardo,

    sorry but although I use Excel2013 that version canŽt convert a picture to a workbook.

    From what it seems your inputboxes are comments, you can activate the view of all via Review/Comments where you can toggle the view. Or right click any of the cells holding a comment and choose the appropriate view.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    04-30-2013
    Location
    Porto
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to display all input messages

    Hi HaHoBe,

    Actually the messages are not comments. In the excel file attached you can see how these messages were inserted. Thanks in advance!
    Attached Files Attached Files

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Macro to display all input messages

    Hi, brunoricardo,

    no chance of displaying more than one note as they are created with Data/Validation which will only be affected by the active cell in the sheet.

    Ciao,
    Holger

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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