brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a listbox in my userform set with bound columns as 3 and column count as 3
I have this code to enter the number in the last column into my workbook
However this is a 13 digit number so I want to enter it as text.
It is actually text in my workbook (the range that populates the listbox) but somehow on entering it, it converts it to a number
I have this code to enter the number in the last column into my workbook
However this is a 13 digit number so I want to enter it as text.
It is actually text in my workbook (the range that populates the listbox) but somehow on entering it, it converts it to a number
VBA Code:
Private Sub CommandEmail_Click()
Range("Invoice!N3").Value = FrmInvoice.ListBox1.Value
Unload FrmInvoice
End Sub