Userform textbox to update column (comment) ?

hi All ,

Hope can advise how to used userform (textbox) to update specific column (comment) text

it it possible in excel ?



Many Thanks to all ,
waihar

Hi All ,

I have attached my codes ,

i just need to used the text box comments to update the comments to column C

Weird is that

Sheet1.Range("C3:C3").SpecialCells(xlCellTypeComments).Cells = Me.txtComment.Value

and

Sheet1.Range("C4:C4").SpecialCells(xlCellTypeComments).Cells = Me.txtComment.Value


Keep updating C3 , column instead , instead my wanted as comment text.

Any suggestion ?

Cheers ,
waiHar

A Million Thanks Andy , it works perfectly