Re: Add text based on imput in another cell

If the user can type into the cell, then you cannot put a formula in the cell also (it will be overwritten by the user's entry). The only way to do what you want is through an event procedure. In order to give you the code you will need, we need some more information. Are you interested in cells C17 and C21 only? Or is this a functionality you need across multiple columns? If multiple columns, which ones (start column, end column)? Always rows 17 and 21, or do other rows need to react to the value typed into C17?

Rick


"HH" <deerlake@xxxxxxxxxxxxx> wrote in message news:kGgSj.45664$%15.17750@xxxxxxxxxxxxxxxxxxxxxxxxx
Rick,
C21 is a general text cell where the user can type comments. There is no formula in this cell now.

"Rick Rothstein (MVP - VB)" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in message news:%23y4UxZ1qIHA.1736@xxxxxxxxxxxxxxxxxxxxxxx
What is in C21 now? By that I mean, does it contain a formula which displays text (if so, tell us the formula) or does it contain text typed in by the user?

Rick


"HH" <deerlake@xxxxxxxxxxxxx> wrote in message news:2j9Sj.1669$_.1332@xxxxxxxxxxxxxxxxxxxxxxxxx
Maybe I was not clear enough - or maybe I don't understand. I'll try again..

If I put a value less than 1980 in cell C17, I would like a text statement added to cell C21. This added text statement would say "Construction material may contain lead." There may already be a text statement in C21 so the new statement would be added at the end of whatever is already in the cell.
What I have come up with is: =If (C17>1980,C21="Construction material may contain lead.","") I think this would delete whatever is already in C21 and replace the Consturction material...statement. But even if it would work - I don't know where to add the =if statement.
Thanks

"HH" <deerlake@xxxxxxxxxxxxx> wrote in message news:rx2Sj.1452$_.1022@xxxxxxxxxxxxxxxxxxxxxxxxx
Based on value in C15 I want to have a text statement added to cell B21. I would like this to be put at the end of whatever is already in B21 - not just replace the cell content.

Need help with the code - and where it would go.

Thanks









.

Relevant Pages

  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning ... That means when the user leaves the cell, ... went to edit the text in C21 and restore it when they were finished. ... Private Sub Worksheet_SelectionChange ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... go back to the worksheet and enter different combinations of dates in C17 and text in C21 to see if the code is doing what you want. ... there may be other text already in the cell when the statement is to be added. ... Or is this a functionality you need across multiple columns? ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... That works great except when I try to manually type something else in C21. ... After I move to another cell the warning reappears along with the ... the worksheet and enter different combinations of dates in C17 and text ... there may be other text already in the cell when the ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... I had to guess at the functionality you would have wanted if C21 was empty and it looks like I guessed incorrectly. ... InStr.Value, Warning) = 0 Then ... go back to the worksheet and enter different combinations of dates in C17 and text in C21 to see if the code is doing what you want. ... there may be other text already in the cell when the statement is to be added. ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... C17 and C21 are the only cells involved. ... there may be other text already in the cell when the ... B21 - not just replace the cell content. ...
    (microsoft.public.excel.programming)