Greetings
FrmAdmin contains a Listbox - LboResult
LboResult has 8 columns. Columns 4 and 5 contain telephone numbers
Column 4 is a Mobile number: 0820000000
Column 5 is a landline number: 0110000000
Sheet2 has Columns Mobile and Telephone, which are custom formatted to accept the respective number formats.
The list box displays the respective numbers correctly.
However the user form TxtMobile.value does not display the leading zero.
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "###-###-####")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "0")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "#0000000000")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "0*")
TxtMobile result is False.
Can someone assist me?
FrmAdmin contains a Listbox - LboResult
LboResult has 8 columns. Columns 4 and 5 contain telephone numbers
Column 4 is a Mobile number: 0820000000
Column 5 is a landline number: 0110000000
Sheet2 has Columns Mobile and Telephone, which are custom formatted to accept the respective number formats.
The list box displays the respective numbers correctly.
However the user form TxtMobile.value does not display the leading zero.
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "###-###-####")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "0")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "#0000000000")
Tried Me.TxtMobile.Value = Me.LboResult.Column(4) = Format(Me.TxtMobile.Value = "0*")
TxtMobile result is False.
Can someone assist me?