Jump to content

Pasar datos de celda a textbox


Recommended Posts

Hace 3 horas, lito dijo:

ocupo que quede en userform y se abra al iniciar excel

 

Y en qué momento se menciona esto en tu consulta?

sube un ejemplo completo de lo que necesitas.

Link to comment
Share on other sites

Private Sub TextBox1_Change()
ActiveSheet.Range("C6").Value = TextBox1.Text
TextBox3 = Range("C8").Text
End Sub

Private Sub TextBox2_Change()
ActiveSheet.Range("C7").Value = TextBox2.Text
TextBox3 = Range("C8").Text
End Sub

Private Sub CommandButton1_Click()
TextBox1 = Empty
TextBox2 = Empty
TextBox3 = Empty
TextBox1.SetFocus
End Sub

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Privacy Policy