Hi
If a user selects a value from a drop down list A31 (data validation) the following list is displayed in 4 other cells (the values in the list will be different depending on what the user selects in A31). I now need to change this a bit and I'm stuck on how to do it. The code I have at the moment is shown below. The user only selects a value from cell A31 at the moment but what I need to happen is that is they select HL7 from A31 and enter a 1 in cell E22 the last line of text e.g. Range("A35").Value = "into… IntegrationH. HL7 integration inbound, outbound arrival & demographic message (price per Trust)" should then say Range("A35").Value = "into… IntegrationH. HL7 integration inbound, outbound arrival, demographic & outcome message (price per Trust)"
Is it possible to do this?
Many thanks
Karen
Bookmarks