Hi,
How to display the inputs to list box. I have a text box which will ask the Product ID and everytime when i click the button add new one, the text box should become empty to get the next input and whatever input that i gave should get display in the list box.
I tired to transfer the data to excel cell and pull that via Row Source in list box, but getting only one value not all. below is the one which i have used.
Code:
Sheets("Sheet5").Range("A1").Value = TextBox1.Text
i cant define the range since, the product ID count is depends and it may be 1 or 10. I'm assuming we need to use FOR loop to get this but not sure about the exact code.
could someone please help on it!!!!
Regards,
Dheepak
How to display the inputs to list box. I have a text box which will ask the Product ID and everytime when i click the button add new one, the text box should become empty to get the next input and whatever input that i gave should get display in the list box.
I tired to transfer the data to excel cell and pull that via Row Source in list box, but getting only one value not all. below is the one which i have used.
Code:
Sheets("Sheet5").Range("A1").Value = TextBox1.Text
i cant define the range since, the product ID count is depends and it may be 1 or 10. I'm assuming we need to use FOR loop to get this but not sure about the exact code.
could someone please help on it!!!!
Regards,
Dheepak
