para hacer referencia a una celda se usa la palabra cells(la fila, la columna) para usar esto en un option button para vb.
la formula de un boton opttion button para sumar
cells(2,3)= cells (2,1) + cells (2,2)
cells(3,3)= cells (3,1) + cells (3,2)
cells(4,3)= cells (4,1) + cells (4,2)
cells(5,3)= cells (5,1) + cells (5,2)
la formula de un boton opttion button para restar
cells(2,3)= cells (2,1) - cells (2,2)
cells(3,3)= cells (3,1) - cells (3,2)
cells(4,3)= cells (4,1) - cells (4,2)
cells(5,3)= cells (5,1) - cells (5,2)
la formula de un boton opttion button para multiplicar.
cells(2,3)= cells (2,1) * cells (2,2)
cells(3,3)= cells (3,1) * cells (3,2)
cells(4,3)= cells (4,1) * cells (4,2)
cells(5,3)= cells (5,1) * cells (5,2)
la formula de un boton opttion button para dividir.
cells(2,3)= cells (2,1) / cells (2,2)
cells(3,3)= cells (3,1) / cells (3,2)
cells(4,3)= cells (4,1) / cells (4,2)
cells(5,3)= cells (5,1) / cells (5,2)
No hay comentarios:
Publicar un comentario