Dear, I need to make a macro emulating the function = TEXT () of EXCEL in vb.
The idea is that by having cells with hours (7:55) the function vb transforms me to 07:55. Usually for this I use = TEXT (cell, "hh: mm"), this transforms it. I need to take that function to visual basic but it does not work for me with the following code:
Sub cambiarFormatohhmm() Dim celda As Range For Each celda In Selection celda.Value = Texto(celda,"hh:mm") Next End Sub