Putting text in a cell on the same row as an edited cell

**London257** · 10-18-2012, 09:20 AM

Hi,

Help!

I have a macro fired from a Worksheet_Change event that I want to run when a cell in column H is set to a value of >= 0.9. The macro opens an InputBox and I want to put the user entered string (strReply) into column S on the same row.

I think I have it almost working, just struggling with 2 things:

1. As you see from the Worksheet_Change sub below I track changes to some columns between C and R and put date and time in column B on change and I still want to do that. But unfortunately all changes to these columns also run my Details macro but I only want the macro to run when column H is changed to >= 0.9 not when other columns are changed or when column H is lower than 0.9.

2. At the moment, if I change column H on any row the macro runs and puts strReply in cell S4 on my sheet called "Test" and I am strugling to work out how to make it put it in column S on the same row as the changed column H cell. Column H is a percentage probability and is manually updated to a value between 10% and 100% and I only want the Details at probabilites of 90% and above.

Please Login or Register  to view this content.

I am not quite a novice but and definitely an amateur.

Regards,
Geoff.

**patel45** · 10-18-2012, 09:31 AM

attach a sample file for testing

**London257** · 10-18-2012, 10:34 AM

Hi,

As requested here is a file to test against. You will see the macro Contract_Details, this is the one I want to use for real but i simplified the text string for the InputBox in macro Details for the forum.

You will also see the worksheet does other things like the row turns blue when H is set to >= 90% and red when H is set to 0% and there is an InsertRows macro.

Regards,
Geoff.

**Cutter** · 10-18-2012, 11:08 AM

@ London257

Welcome to the forum.

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

**patel45** · 10-18-2012, 01:40 PM

for now make this change and test

Please Login or Register  to view this content.

why do you use regexp ?

**London257** · 10-19-2012, 01:23 AM

patel45,

Thanks that works perfectly and it is much more efficient than my code. I used regexp because it was the first way I managed to get the macro to do what I wanted to do, as I said I am not a novice but definitely an amateur. Thanks once again for your help.

Regards,
Geoff.