ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform txt box updates spreadsheet (https://www.excelbanter.com/excel-programming/301756-userform-txt-box-updates-spreadsheet.html)

dok112[_8_]

userform txt box updates spreadsheet
 
Ok...I have a template spreadsheet that is attached to a userform that
created. When I type in TextBox1, I want it to put that data into cel
C4. What is the correct code

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

userform txt box updates spreadsheet
 
Private Sub Textbox1_AfterUpdate()
ActiveSheet.Range("C4").Value = _
Textbox1.Value
End Sub

--
Regards,
Tom Ogilvy

"dok112 " wrote in message
...
Ok...I have a template spreadsheet that is attached to a userform that I
created. When I type in TextBox1, I want it to put that data into cell
C4. What is the correct code?


---
Message posted from http://www.ExcelForum.com/




gitcypher[_8_]

userform txt box updates spreadsheet
 
Range("C4").Value = TextBox1.Valu

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com