Copy cell text into form

[VickyC]

Hello,

I have a table that I have protected so that users are not able to edit directly into the table.

I am wanting the users to click on Edit, which then opens a form, but I need to copy the text already entered into a cell within the table into a textbox on the form, but I am having problems finding the correct syntax to do this??

If anyone can advise it would be much appreciated.

Thanks in advance.

[kadghar]

Hello,

I have a table that I have protected so that users are not able to edit directly into the table.

I am wanting the users to click on Edit, which then opens a form, but I need to copy the text already entered into a cell within the table into a textbox on the form, but I am having problems finding the correct syntax to do this??

If anyone can advise it would be much appreciated.

Thanks in advance.

hi Vicky

textbox1.text = cells(3,2) <---will write cell B3

or

textbox1.text = range("B3")

HTH

[Killer42]

Can you just clarify what sort of environment we're talking about? What are you referring to by the terms "cell" and "table", for instance? Is this Word? Excel? Access? Standalone VB? What version?