Taking Data of cell from worksheet to a userform window

B

Bob Phillips

Mete,

As an example to a textbox

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

Tom Ogilvy

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
 
M

Mete Kavruk - EXPARTIZ

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
change controlsource for textbox depending on combobox selection 2
Date showing as numbers in Textbox on Userform 2
Arbitrary data to Textboxes in UserForm 4
Excel 2013 Merge Data 2
Copy filtered data to sheet 2 1
Pasted text will not spell check 5
Copy from a text box 4

Top