I need a text box to form to point to a cell

**whizbee** · 09-25-2013, 05:23 PM

I am creating an Excel form and I need a fill in the blank field. I need the field to point to a cell.

I am currently trying to use an ActiveX Text Field, but I cannot make it point to a cell.

The reason why I do not want to use a cell is because I am using other form controls and it wouldn't look right.

Thanks in advance!

**mehmetcik** · 09-26-2013, 01:59 PM

Try using a sheet specific macro to copy the contents of your cell into the textbox whenever the sheet is changed.

Right click on the sheet name at the bottom of excel and select view code

paste this into the sheet

modify it to meet your requirement.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.count > 1 Then Exit Sub

textbox 1,value = range("A1").value

exit sub

To the Moderators. I cannot see how to insert code tags.

**Fotis1991** · 09-26-2013, 02:08 PM

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found [URL="http://www.excelforum.com/misc.php?do=bbcode"]here[/URL

Edit: I believe that you know that if you don't do this it's a violation of rule#3 of our forum.