[RESOLVED] Excel - VBA

[TomGibbons]

How can I specify a cell to use as input and output? I am pretty new to VBA in excel

[alex_read]

What are you trying to do here Tom, can you give me an idea of your project as I'm not sure what you're trying to achieve here.

Thanks

[TomGibbons]

It's pretty simple, I'm just not very good at explaining. I want to get text from, and put text in a cell that I know the co-ords of.

[alex_read]

ahhh, okay, there's 2 main ways of doing this, either using the Range object, or the Cells object. I personally prefer using the range as it's easier.

To run these, open Excel & add a button onto the spreadsheet. Double click onto the button to get to the code window & enter the following code.

Using the range, you specify the letter of the column & the row number, so the first cell is referenced as A1. This returns a value in a messagbox for you.

Private Sub CommandButton1_Click()
    MsgBox Sheets("Sheet1").Range("A1").Value
End Sub

The cells way works backwards, you specify a number for the row first, followed by a number for the column, both of these make up a reference to a cell - so the first cell will be referenced as 1,1. This sample places a value into the cell:

Private Sub CommandButton1_Click()
    Sheets("Sheet1").Cells(1, 1).Value = "A Value"
End Sub

[TomGibbons]

Thanks alot Alex