Hi, Can somebody help me
I am creating a macro in excel and I want to take input from user.
user can give address of any column,row,cell and may be insert perticuler value.and after that I work on that data and response Excel User.
Thanks in advane

you can make a userform that fullfils your needs.
use:
to show the form
put u commandbutton on the form to close the form
put the following code in the commandbutton click event:
The textbox properties are still readable after this.
Now you can read the values from the forms textboxes:
etc.
after that you can unload the form:
The textbox properties are lost after this.