Enter contents from listbox as text

[brianfosterblack]

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

Private Sub CommandEmail_Click()
    Range("Invoice!N3").Value = FrmInvoice.ListBox1.Value
    Unload FrmInvoice
End Sub

 

[Anthony47]

Try Range("Invoice!N3").Value = "'" & FrmInvoice.ListBox1.Value

Bye

 

[brianfosterblack]

Try Range("Invoice!N3").Value = "'" & FrmInvoice.ListBox1.Value

Bye

Wow, this works perfectly. However I do not understand why? Thank you

 

[Anthony47]

Odi et amo. Quare id faciam, fortasse requiris.
Nescio, sed fieri sentio et excrucior.

In this case the the why is easy to explain: I add a "single quotation mark" at the beginning of the texbox value, and this symbol is for excel the prefix for "text"

Bye

 

[Fluff]

@brianfosterblack
In future when marking as solution can you please mark the post that has helped, rather than your post saying it worked. I have changed it for you this time. Thanks

 

[brianfosterblack]

In this case the the why is easy to explain: I add a "single quotation mark" at the beginning of the texbox value, and this symbol is for excel the prefix for "text"

Bye

Thank you, I understand now