+ Reply to Thread
Results 1 to 8 of 8

Alter Generic text created by dropdown

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Dover
    MS-Off Ver
    Excel 2003
    Posts
    16

    Alter Generic text created by dropdown

    I have created a spreadsheet where in cell A3 is a dropdown list and when a selection is made from the dropdown list this auto populates a paragraph of text in cell D4. My problem is that the text populated in cell D4 needs to editable?When I try to edit the text the formula is show and the text disappears??

    Anybody know if this is possible? If yes then how would I go about it please?

    Many Thanks,

    Yidolee.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Alter Generic text created by dropdown

    Is D4 a formula that uses A3 as the subject of say a VLOOKUP to return the text?

    If so I'd perhaps be inclined to use the SheetChange event procedure in VBA to detect a change to A4 and have the procedure populate D4 with the relevant text. Then you could freely edit D4.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Alter Generic text created by dropdown

    Other than VBA code (which Richard suggests), this is not possible - a cell can contain either data (numbers/text you enter) or a formula, not both, and entering 1 will replace/overwrite the other
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    01-14-2013
    Location
    Dover
    MS-Off Ver
    Excel 2003
    Posts
    16
    Quote Originally Posted by Richard Buttrey View Post
    Is D4 a formula that uses A3 as the subject of say a VLOOKUP to return the text?

    If so I'd perhaps be inclined to use the SheetChange event procedure in VBA to detect a change to A4 and have the procedure populate D4 with the relevant text. Then you could freely edit D4.
    I am indeed using VLOOKUP as I have no experience in writing (creating) VBA or using it?? Any assistance would be a great help??

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Dover
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Alter Generic text created by dropdown

    Thank you for your assistance Richard and FDibbins.Is there any chance you could possibly create the VBA for me please?Or anywhere I could get it from??

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Alter Generic text created by dropdown

    Hi,

    See attached. The Sheet_Change macro is
    Please Login or Register  to view this content.
    A11 is a Vlookup that looks up the text paragraphs from a lookup table driven by A3
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-14-2013
    Location
    Dover
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Alter Generic text created by dropdown

    Thanks for your help again Richard. There is one more problem,I have never used VBA before so where and how would I apply it to work?

    Many Thanks

    Yidolee

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Alter Generic text created by dropdown

    As always with Excel there are several ways into the VB Code. Perhaps the simplest would be to right click the sheet tab name and choose 'View Code'.

    You'll now see two drop down boxes over on the right. In the lefy hand drop down select 'Worksheet', in the right hand drop down (which will default to SelectionChange, pick the 'Change' event.

    Now put the code I gave you inside the
    Please Login or Register  to view this content.
    code block. Obviously only put the code in there, not the Sub Worksheet...and End Sub. i.e. the stuff beginning with
    If Not Intersect....

+ 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] Alter Code for Copy and Paste of Data to Created New Sheets.
    By Ortz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 10:32 PM
  2. i have created a dropdown
    By VINU P V in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2012, 07:48 AM
  3. How to sort dropdown list created though data validation tool?
    By chitian5057 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-11-2010, 10:32 PM
  4. Automatically Populate dropdown for each new worksheet created
    By ahmed-k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2010, 02:16 PM
  5. Dropdown list created with dependent cell value
    By jchambers00 in forum Excel General
    Replies: 3
    Last Post: 03-04-2009, 10:26 AM
  6. Alter value in one cell alter value in multiple cells
    By Bryan Noqw in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-11-2008, 05:31 AM
  7. Created Dropdown list - How to change Font?
    By JonPugh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2007, 07:24 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