Forum Discussion

JK-DB's avatar
JK-DB
Copper Contributor
Jul 13, 2023

Text when i click a cell.

Hi,

Is het possible to make a textbox visable (or something) (wherever) when i only click on a certain cel?

also it must not matter that there somthing in that cell or not.

 

Im not seeking info about adding a note or remarks in that cel

 

How do i do this and does somebody maby have a Macro.

 

Thx! 

excel
Formulas and Functions
Macros and VBA

3 Replies

Sort By
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Jul 13, 2023

    Hi JK-DB ,

     

    yes, you could use data validation for that cell (or cells).

     

    Whenever the cell is selected, the input message appears.

     

    Kind regards,

    Martin

     

    • JK-DB's avatar
      JK-DB
      Copper Contributor
      Jul 14, 2023

      Martin_Weiss 

       

      Thx for your response!

      it’s a step in the right direction 🙂 

      is it possible in your given option or another way to determine where the text shows up?

      in a fixed specific location.

       

       

      Please help thx again!

      • Martin_Weiss's avatar
        Martin_Weiss
        Bronze Contributor
        Jul 14, 2023

        Hi JK-DB ,

         

        unfortunately, it is not possible to determine the exact position of that text box. It's a standard feature of Excel, that always appears below the active cell.

         

        Kind regards,

        Martin

Resources