Copying values from two different cells and a value from an input box onto different cell

[subbby]

Wanting know how to copy values from two different cells and a user input (given using INPUT BOX) ; onto a cell.

Eg.

Cells(1,1)=Excel
Cells(1,2)=Forum

User Input = SMILEY


Desired Value of Cell(4,4) = Excel_SMILEY_Forum



Discussed on copying a input box value alone onto a cell, on
http://www.excelforum.com/excel-prog...58#post2915858


is it on the same lines?

Thanks,

Subbby

[BigBas]

Cells(4,4) = Cstr(cells(1,1) & "_" & Userinput & "_" & Cells(1,2))

For userinput, use whichever variable your've chosen to store the inputbox response.

Does this work?

[subbby]

It worked .... Thanks...

May i know wats "Cstr" syntax stand for?

[BigBas]

Subby. This look should provide some clarity. In this case, I don't even believe the CSTR is necessary, but I prefer to use it.

http://www.techonthenet.com/excel/formulas/cstr.php

[subbby]

Subby. This look should provide some clarity. In this case, I don't even believe the CSTR is necessary, but I prefer to use it.

http://www.techonthenet.com/excel/formulas/cstr.php

Thank you very much ! helpful it was ...