Thanks for the update. This what I also think. But I am not able to know its
value. I have a userform1 which has a textbox1 where user enter some value. I
would like to know what is the value. Below are the code.
Private Sub CommandButton1_Click()
Dim WSheet As Worksheet
For Each WSheet In
Hi,
Please let me know how to obtain the content of a text box of user form?
Thanks
Hiren
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mis-transmission. If
Hi Hiren,
Suppose I have a veriable called Fname now I have to get this
variable's value from a Texbox in a user control. Lets take this Text Box
name as Textbox1 now I will use
Fname = Textbox1.value to populate my Fname variable with the value present
in the Text Box. Textbox1.value is the