
Respuestas de la comunidad
-
Antoni's post in Error al Guardar Información de un Label was marked as the answerNo todos los controles tienen las mismas propiedades:
Private Sub Guardar(sh As Worksheet, r As String, ctrl As Control) If ctrl.Visible Then Select Case TypeName(ctrl) Case "Label" sh.Range(r).Value = ctrl.Caption Case "TextBox" sh.Range(r).Value = ctrl.Value End Select End If End Sub
-
Antoni's post in Macro ocultar un rango indicado pero menos celdas o celda seleccionadas was marked as the answerSub OcultaFilas() Rows("8:20").EntireRow.Hidden = True 'ocultar rango Selection.EntireRow.Hidden = False 'mostrar selección End Sub