Textbox rowsource

[ganesh_05]

Hi friends...

I have been facing a problem with textbox rowsource method....

is the following syntax a correct one??

textbox1.rowsource = "Demand!A3:Y100"

Demand is sheet name...

do i need to change any of text box properties ??

When i m running the form... i m facing the following error ...

"Couldnot set the rowsource property. Member not found."

Any help.. ??

Thanks in advance...
Ganesh.

 

[tactps]

Rowsource is only used for list boxes or combo boxes, not text boxes.

 

[Fat Cat]

You normally assign data to a TextBox by;

TextBox1.Text = Sheets("Demand").Range("A1").Value

or

TextBox1.Text = Sheets("Demand").Cells(1,1).Value

If you want to display data from more than 1 cell on the spreadsheet in the same textbox at the same time, you need to add the data together first, you can't assign from several cells at the same time.

eg:

Dim myText as variant

For i = 1 to 10
myText = myText & Sheets(1).Cells(i,1) & vbCr
Next i

TextBox1.Text = myText

 

[Norie]

RowSource is not a property of a textbox.

 

[ganesh_05]

Thank you very much for your replies...

but when i checked the help from excel... it says abt text box as...

"A TextBox is the control most commonly used to display information entered by a user. Also, it can display a set of data, such as a table, query, worksheet, or a calculation result. If a TextBox is bound to a data source, then changing the contents of the TextBox also changes the value of the bound data source."

I want to populate a table in the textbox and the table is from a worksheet ... so i want to bound the textbox to a data source (here it is DEMAND sheet)... my user can edit the table thats y i m not using listbox here...

is it not possible??

and when i was writing the code... it is populating rowsource property/method when i write textbox... then how come rowsource doesn't apply to textbox??

 

[ganesh_05]

Ok now i understand that rowsource is not a textbox's property...

can u please suggest me a way to bound the textbox to a data source... i want the textbox to display a table...

 

[tactps]

VBA help for "rowsrouce property":

Specifies the source providing a list for a ComboBox or ListBox.

No mention of textboxes there.

Fat Cat has a solution for you.

 

[ganesh_05]

hii...

I dont think i can display a table using fat cat's solution... can I ??

 

[Fat Cat]

You could display a table if you use a multicolumn ListBox.

If your data is in consecutive columns, just use the RowSource property to fill it with the data.

Otherwise you need to create an array and fill that with the data you want, then assign the array to the ListBox.

 

[ganesh_05]

I want to allow the user to edit the data...

But the user can't edit the data if i provide the data with a listbox...

thats y i m using a textbox...