| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Taking Data of cell from worksheet to a userform window
How can i Take a Data of cell from worksheet to a userform window?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| taking certian data from worksheet one to worksheet 2 | Excel Worksheet Functions | |||
| Properties window show nothing for a userform | Excel Discussion (Misc queries) | |||
| Gray Bar Taking up Half of Excel Window | Excel Discussion (Misc queries) | |||
| Taking data from another worksheet and converting | Excel Worksheet Functions | |||
| Anchor a Userform to a cell in the worksheet | Excel Programming | |||
![Bob Phillips[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
