+ Reply to Thread
Results 1 to 2 of 2

Solution for a dynamic and space friendly comment/popup

  1. #1
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Solution for a dynamic and space friendly comment/popup

    Hi,

    I come to seek advice for a problem. I am looking for a way to have the user select a button or other means of input and when doing so, a bubble or box comes up and gives them some text. The text inside this display would be dynamic. The text is used as instructions and will change based upon other cell values. Reason I need this specific solution is because it is space friendly. I do not want to display a text box at the top of the sheet because it will be in the way. Rather I would like the user to just have to click on the button and display the instructions.

    I could do this with a msg.box but was wondering if theres any better ways.

    VBA is obviously OK.

    Thank you

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Solution for a dynamic and space friendly comment/popup

    How about using data validation. You can set title and message text.
    In order to make it dynamic you could use code in the SelectionChange event of the worksheet.

    Or you could use a keyboard shortcut which would display the message box.
    Cheers
    Andy
    www.andypope.info

+ 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] Runtime error '28'..... out of stack space solution!!
    By meus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-12-2015, 05:58 AM
  2. Need dynamic message in validation popup
    By ken66220 in forum Excel General
    Replies: 0
    Last Post: 10-10-2012, 12:44 PM
  3. [SOLVED] Solver macro... bypass no feasible solution popup
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2012, 05:28 PM
  4. Sensitivity and solution space
    By abha in forum Excel General
    Replies: 11
    Last Post: 11-21-2011, 12:55 PM
  5. Popup or comment on the column feilds using VBA
    By abhishek_09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2009, 05:36 PM
  6. Userform Comment box popup
    By R0bert0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2007, 09:48 AM
  7. [SOLVED] Popup TextBox/Comment
    By Robert Brydges in forum Excel General
    Replies: 2
    Last Post: 01-19-2006, 08:25 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