Formula in a string variable

[durgy]

I am concatenating 2 strings str1 and str3 in strTotal in Userforms VBA Excel 2007
When I save userform strTotal = str1 & str3 goes in sheet1!A2 and works fine.

Now there is requirement that I have to add a reference to sheet1!B2 in between the string. i.e when I save userform
strTotal = str1 & (something like =B2 ) & str3 goes in sheet1!A2. Later when user enters a value in B2 (which can vary) this value goes between str1 and str3 in sheet1!A2.
I have to do similar for 100 rows.
I am not sure how to do by VBA. I trying to avoid doing this by formula on the sheet.

Thanks

 

[durgy]

Thanks repairman615 the code works.

One thing I noticed is the first time user entry in C2 updates A2 correctly. But if the user comes back and edits/deletes C2 second time A2 does not update.
I am not sure what I am doing wrong.

Thanks

 

[repairman615]

Hello,

Glad to hear the progress. Sounds like adding some additional code may work out the logic of what should happen.

What exactly would you like to happen on the second time?

How about for the third or more?

I did notice this while I was writing it... I was just glad to mainly get it working and did not know if that was an issure with your needs.

 

[durgy]

Hello,

Thanks repairman615 you have pointed me in the right direction. never how many times the user will edit/delete.
I think I will be able to work out the additional code.

Thanks a lot for your help. Greatly appreciated

 

[repairman615]

Your welcome, glad to help.

Feel free to post back if you get stuck.