Member Avatar for Ravi Singhal

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

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by PVBert
Member Avatar for PVBert

you can make a userform that fullfils your needs.
use:

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
   UserForm1.Hide
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

etc.
after that you can unload the form:

Unload UserForm1

The textbox properties are lost after this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.