2 Values in cell

[yabbadabba]

Hi Guys, Just wondering if it is possible to put 2 values in 1 cell. I have a userform with a 2 textboxes, 1 with a numbered value in it and the other with a lettered value in it. For example the cell value might look like this 'N8'.Any help would be appreciated. Thanks

 

[AlphaFrog]

Try something like this...

Range("A1").Value = TextBox1.Value & TextBox2.Value

 

[yabbadabba]

lol, thanx for that. wasn't sure if that would work and it did.