vb help textbox / row

[Kris75]

How do i populate several text boxes in a userform from one row of data
example
Combo box 1 = a1
textbox1 = b1
textbox2=c1
textbox3=d1

etc

The combo box will be selecting which row i choose

 

[SteveO59L]

Use the Linked cell property

 

[Kris75]

Use the Linked cell property

I'm fairly new to Vb, and google is no good
how can i access the linked cell property

 

[SteveO59L]

How did you create your text boxes ?

 

[Kris75]

From the tool box

 

[SteveO59L]

Drawing, Forms or Controls ?

 

[Kris75]

from the control toolbox

Sorry, I thought this would be easier

i have 12 columns of data, and i want to populate each textbox with that data row by row based on the data from the column A

 

[SteveO59L]

Ok, on the Controls Toolbox, you should see an icon with a set square/ruler. Select this and it will allow you to select your text box.

Right-click on your text box and select the properties option.

About halfway down the properties dialog is the Linked Cell, populate this with whatever cell you want to link to.

 

[Kris75]

I'm using Excel 2003 - and cannot see the linked cell option in properties
am i just being being really thick?

 

[SteveO59L]

Are you sure that you created your text box from the Controls toolbox ?.

When you right click on your box, what do you get as options ?