RE: $$Excel-Macros$$ how to know the content of a text box of user form

2010-11-12 Thread Hiren Sheth
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

$$Excel-Macros$$ how to know the content of a text box of user form

2010-11-11 Thread Hiren Sheth
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

Re: $$Excel-Macros$$ how to know the content of a text box of user form

2010-11-11 Thread Deepak Rai
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