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.

UserForm1.Show vbModal

to show the form
put u commandbutton on the form to close the form
put the following code in the commandbutton click event:

Sub Command1.Click
End Sub

The textbox properties are still readable after this.
Now you can read the values from the forms textboxes:

Dim sAnswer as String
sAnswer = Userform1.Textbox1.Text

after that you can unload the form:

Unload UserForm1

The textbox properties are lost after this.