accept user input from excel

[punx78]

what is the code to make a box popup in an excel worksheet to accept a user inputted string?

I know how to do yes / no questions but i just need a simple input screen so that i can accept the string as a variable in VB to modify it and return it to a specific cell with my worksheet

 

[Chattin]

Have a look in the VBE help on InputBox Function

HTH