Textbox changes Cell format to Text

[FreakSister286]

Excel 2007 Textbox changes LinkedCell Cell format to Text. If I do a VLOOKUP on that cell it fails and I have to "Convert to number".
My application is to enter a ZIPCODE into ZIP textbox, then for CITY and STATE to autofill using VLOOKUP in both CITY and STATE cells.

 

[FreakSister286]

This is what I have in VBA:
-----------------
Private Sub ZIP_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyTab Then
Address.Activate
End If
End Sub
-----------------
What code will automatically convert the underlying cell to Number format? and then keydown to my next textbox?

 

[Norie]

What code puts the value from the textbox into the cell?

 

[FreakSister286]

Hi Norie,

Thanks for responding. You may not have seen my earlier post so I'll combine the two:

"Excel 2007 Textbox changes LinkedCell Cell format to Text. If I do a VLOOKUP on that cell it fails and I have to "Convert to number".
My application is to enter a ZIPCODE into ZIP textbox, then for CITY and STATE to autofill using VLOOKUP in both CITY and STATE cells.

This is what I have in VBA:

Private Sub ZIP_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyTab Then
Address.Activate
End If
End Sub

What code will automatically convert the underlying cell to Number format? and then keydown to my next textbox?"

 

[Norie]

I think that's the problem - using a linked cell.

The link works both ways, so if you enter anything in the textbox it's put in the cell, and since it's a textbox it's text.

You could probably use code to convert it buy it might be easier to do the conversion in the formula.

For that you can try the VALUE function, something like this where A2 is the linked cell.

=VLOOKUP(VALUE(A2), LookupRange, Column, 0)

 

[FreakSister286]

Norie! You are a Genius! Sloppy kisses! TY TY!