Making Textbox act like a cell???

  • Thread starter Thread starter CWit
  • Start date Start date
C

CWit

Ok, trying something new, If I have the textbox linked to cell A1 on th
same sheet. How do I get the textbox to act like the cell. For instanc
if I type " 1000 " then press "Enter". I want it to be like typin
"1000 " into the cell and most importantly press "enter"

I know how to link the cell, I just need the code to make the Texbox t
act like the cell upon pressing enter
 
Here is a revolutionary idea. Why don't you use a cell, it acts exactly like
a cell<vbg>

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
CWit;

What exactly do you want.
Is the textbox on the worksheet, or on a userform and do you want this
textbox to be updated everytime you
enter a value in the cell ?
This did not become clear to me.

Mark.
 
Thanks Bob love the comment..... Next Time I hope to think about tha
myself.

Anyway, to answer your question Tom the textbox and the cell are on th
same sheet. The reason why I can't just use the Cell "BOB" is fo
graphical issues
 
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then
Range("A2").Select
End If
End Sub


You could make it more dynamic to determine whether to move to the right or
go down one cell or to dynamically determine what cell it is positioned over
or linked to.

Assumes a textbox from the control toolbox toolbar.
 
Thanks Bob love the comment..... Next Time I hope to think about tha
myself.

Anyway, to answer your question Tom the textbox and the cell are on th
same sheet. The reason why I can't just use the Cell "BOB" is fo
graphical issues
 
Back
Top