riyasen
06-23-2011, 08:26 PM
Hi All,
I want Fetch values from vba form based on the input values given in the textbox.
Eg : Say if i enter a value 1 in textbox and click on OK button, this textbox value should be displayed in excel "sheet1" - cell (A1).
I could get this by the below code for a single cell(A1):
Range("A1").Value = TextBox1.Text
output
------
1
If i again enter the value in the textbox , it should display in the next cell i.e (A2).
output
------
1
2
Could anyone please help me on the above??
I want Fetch values from vba form based on the input values given in the textbox.
Eg : Say if i enter a value 1 in textbox and click on OK button, this textbox value should be displayed in excel "sheet1" - cell (A1).
I could get this by the below code for a single cell(A1):
Range("A1").Value = TextBox1.Text
output
------
1
If i again enter the value in the textbox , it should display in the next cell i.e (A2).
output
------
1
2
Could anyone please help me on the above??