+ Reply to Thread
Results 1 to 8 of 8

Doubleclick on cell in range and open textbox or other cell in help column

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Doubleclick on cell in range and open textbox or other cell in help column

    Hi. I have tried look at this and cant really find out the best way to do it.

    I have a part of a sheet with many formulas, and i cant really change that to example insert extra column, it will give a huge work.
    In Sheet2 fram range B6 to B370 i would need to be able to put separate text which refer to cell B6. I can t mix the text which is there now .
    My idea was maybe there can be a way to double click on cell B6 and then open a text box which i can write in and copy from.
    If like that it have to be a specific text box for each cell.
    Or other way could be to double click cell B6 and example open a help column and cell AM6 and here write the text. And maybe have text boxes in this help column.
    So it was like double click B6 go to AM6, B7 go to AM7, B8 go to AM8, All the way down to B370 and AM370

    I am not sure which and how it can be done, maybe other ways are better, The only thing is i cant insert a column.

    Please have a look i have attached a test sheet you can try and play with .
    Thanks in advance
    Sincerely
    Abjac
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    Try it like this: double-clicking on a cell in that range will open a prompt for a comment, that will be stored in column AM of the same row.



    1) Copy this code.
    2) Right-Click the sheet tab of interest.
    3) Select "View Code"
    4) Paste the code into the window that appears.
    5) Save the file as a macro-enabled .xlsm file.
    6) Make changes as needed

    This version overwrites whatever already exists there:

    Please Login or Register  to view this content.
    This version will keep any old comments and append new comments:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    Hi Bernie and thanks so much look at this. I tried both codes and it works. There only one problem. When i double click i need to be able to see the text. Also the text i paste in can easily be in 20 lines. Its a long description. In this case a input box i cant see the text i paste in. And i cant example open it again and see the text all ready in there and then example add to the existing text or delete it. So its working but not really friendly to use and not tot totally what i would love to have to be honest. I wish could be done with a text box which are saved in column AM. Maybe i did not describe it enough. But upper is my problem.
    Any ideas how it can be solved so i can double click and see all text and add to it or paste more, or delete it manually.
    Hope you have time to have a look at that.

    Thanks so far.
    Sincerely
    Abjac

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    You could change

    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    Hi Bernie and thanks but it dont really work.
    I cant paste in only write.
    Now true i can read old text
    but i cant delete it or change, only see it and also it dont really overwrite.
    I really need some where i can open and change, paste also and delete. I think it need to be some kind of text box.
    Could you if time try use my test sheet. I am in Madrid now, so will go bed but i will check tomorrow.
    But this solution with a input box not really optimal. I need to be able to edit and delete and paste when i open.

    Please if time have a look.
    Thanks
    Abjac

  6. #6
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    Try it like this, in the attached.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    WOW Bernie. Thats exactly what i would like. It works so good. I just need add a macro to be sure the row height dont go back to same height. But thats easy. Bernie its a great solution really. So thanks so much for your efford. Its highly appriciated.
    Have a nice day.
    Sincerely Abjac

  8. #8
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Doubleclick on cell in range and open textbox or other cell in help column

    Great - glad to hear that I helped.

    Stay safe...

+ 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. vba when doubleclick a cell, copies from above based on a condition of a cell above
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2019, 03:55 AM
  2. Replies: 0
    Last Post: 07-25-2018, 08:42 PM
  3. Need to add userform textbox information to next open cell in column.
    By dollada06 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2016, 03:40 PM
  4. [SOLVED] VBA -- DoubleClick on Cell with Value = 1
    By HighOctane in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-01-2015, 11:26 PM
  5. [SOLVED] Doubleclick cell to enter value in range
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2014, 07:18 AM
  6. Auto increment textbox value to next open cell
    By chriscoetser in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2012, 07:21 AM
  7. What does DoubleClick on a cell do?
    By surotkin in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 08:51 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