ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Taking Data of cell from worksheet to a userform window (https://www.excelbanter.com/excel-programming/276168-taking-data-cell-worksheet-userform-window.html)

Bob Phillips[_5_]

Taking Data of cell from worksheet to a userform window
 
Mete,

As an example to a textbox

Textbox1.Text = Worksheets("Sheet1").Range("A1").Value

--

HTH

Bob Phillips

"Mete Kavruk - EXPARTIZ" wrote in
message ...
How can i Take a Data of cell from worksheet to a userform window?






Tom Ogilvy

Taking Data of cell from worksheet to a userform window
 
Userform1.Textbox1.Text = Worksheets("Sheet1").Range("A1").Value

or if you want it formatted as it appears on the screen

Userform1.Textbox1.Text = Worksheets("Sheet1").Range("A1").Text

--
Regards,
Tom Ogilvy


"Mete Kavruk - EXPARTIZ" wrote in
message ...
How can i Take a Data of cell from worksheet to a userform window?






Mete Kavruk - EXPARTIZ

Taking Data of cell from worksheet to a userform window
 
How can i Take a Data of cell from worksheet to a userform window?





All times are GMT +1. The time now is 11:09 AM.

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