Excel to Code

[mattcasim]

In a vba application, what code would I use to get the contents of a cell (e.g. G5) into a textbox1?

Also, how do you make a range of cells static so when you scroll down the workbook, those cells stay at the top always?

 

[vconfused]

For the second question, go to the row below the rows you want to stay still and go to Window->Freeze Panes.

For example, if you click in Cell C2 and go to Window->Freeze Panes, then Row 1 will stay and columns A and B will stay. If you click in cell A3, and go to Window->Freeze Panes, then rows 1 and 2 will stay.

 

[Scott Huish]

Try setting the LinkedCell property on the textbox to G5

 

[mattcasim]

linked cell - what code do that use, say if I wanted to apply the cell contents to label1.caption or into a drop down menu?

Thanks

 

[Scott Huish]

LinkedCell is a property of the TextBox, because that is what you originally asked.

Can you provide some details of your project?

 

[mattcasim]

I've got a basic spreadsheet but I want to add VBA and a userform so that user can change the details by using the form rather thna modifying the cells. There is a button to load the userform then I want to have a combo / list box to display current titles, from a range A2:A8 (I have named that range "title"). I need code that will load the combo box with the contents of cells A2:A8. I also need to load the contents of cell B5 into a label. (e.g. label.caption = ...) I do not know what the link cell command does as I have intermediate VB knowledge but very little knowledge of Excel so I am struggling to link the two.

Many Thanks