textBox formatting

[farhad]

Good Day

I m trying to capture MAC Addresses on computer onto a user form.

When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address.

My code is as follows:

[CODEws.Cells(iRow, 40).Value = Me.TextBox77.Value = Format(Me.TextBox77.Value, "MM:MM:MM:SS:SS:SS")][/CODE]

I would prefer that on my Userform Textbox77 be shown as 00:00:00:00:00:00

Thanks

 

[Rick Rothstein]

Good Day

I m trying to capture MAC Addresses on computer onto a user form.

When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address.

My code is as follows:

ws.Cells(iRow, 40).Value = [B][COLOR="#FF0000"]Me.TextBox77.Value =[/COLOR][/B] Format(Me.TextBox77.Value, "MM:MM:MM:SS:SS:SS")

I would prefer that on my Userform Textbox77 be shown as 00:00:00:00:00:00

You are getting the Boolean response because your code line assigns to ws.Cells(iRow, 40).Value the result of comparing Me.TextBox77.Value with Format(Me.TextBox77.Value, "MM:MM:MM:SS:SS:SS"). I suspect the part I highlighted in red above should be deleted. Once you do that, I am not so sure your Format display pattern will work correctly. Can you show us what your MAC addresses in the TextBox will look like?

 

[farhad]

Hi Rick

Thanks for your suggestion. Works Perfectly fine
Once again thanks