Thread: Taking Data of cell from worksheet to a userform window
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?





Reply With QuoteReply With Quote