Taking Data of cell from worksheet to a userform window

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

Mete,

As an example to a textbox

Textbox1.Text = Worksheets("Sheet1").Range("A1").Value
 
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
 
How can i Take a Data of cell from worksheet to a userform window?
 
You must log in or register to reply here.

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
Arbitrary data to Textboxes in UserForm 4
change controlsource for textbox depending on combobox selection 2
Load Userform from Array using a Loop 4
Date showing as numbers in Textbox on Userform 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Pasted text will not spell check 5
Accounting Format Text in a Textbox 4

Back
Top