How to insert data into a worksheet 1

[PartyGoerGeek]

My Name is Paul, I am a new guy in Excel. I need some advise in how to insert data into a worksheet from VBA form, example: in my form I have a text box, I want the value of the text box inserted into a worksheet at a spesific column. or if you have any free e-book or free refrence. Please Let me know. Thanx.


Regards,


PartyGoerGeek.

 

[SkipVought]

Hi,
Assuming that YourColumn has a heading in row 1...

With YourSheetObject
   lRow = Application.Counta(Columns(YourColumn)) + 1 
   .cells(lRow, YourColumn).value = YourTextBoxObject.Text
End with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PartyGoerGeek]

Thanx, your post are really helping me.

PartyGoerGeek

 

[nodrog77]

Hi,

Good online resource is:

http://www.cpearson.com/

It's been pretty useful for me over the years and is a good starting point

Lea

 

[Glenzil]

Assuming you're writing a macro within a workbook and you want to write data into cell A1, you could use the following:

Worksheets("YourSheetName").Activate
ActiveSheet.Range("A1").Value = formName.txtBoxName

You can also reference the worksheet by number eg
Worksheets(1).Activate

 

[PHV]

Glenzil, it's often best to avoid Activate and Select:
Worksheets("YourSheetName").Range("A1").Value = formName.txtBoxName.Text

 

[PartyGoerGeek]

Thanx guyz... Your advice really help me a lot...

 

[Glenzil]

PHV, Yes I agree your method of referencing the cell is much cleaner and tidier. I stand corrected.