| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box in a userform to equal a cell
I need a userform text box to equal B5 on sheet Cycle data in the same
spread sheet. Cannot figure this out Please help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box in a userform to equal a cell
Private Sub UserForm_Initialize()
Me.TextBox1.Value = Range("B5").Value End Sub " wrote: I need a userform text box to equal B5 on sheet Cycle data in the same spread sheet. Cannot figure this out Please help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box in a userform to equal a cell
You forgot the worksheet (which I think is named "Cycle data")...
Private Sub UserForm_Initialize() Me.TextBox1.Value = Worksheets("Cycle data").Range("B5").Value End Sub Rick "Office_Novice" wrote in message ... Private Sub UserForm_Initialize() Me.TextBox1.Value = Range("B5").Value End Sub " wrote: I need a userform text box to equal B5 on sheet Cycle data in the same spread sheet. Cannot figure this out Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make text in a cell equal a number | Excel Discussion (Misc queries) | |||
| Need cell color to equal text | Excel Discussion (Misc queries) | |||
| Userform comobox equal to first 3 digits in a cell | Excel Programming | |||
| How can I make an excel cell equal to the value of a text box | Excel Worksheet Functions | |||
| How to make a cell equal text | Excel Programming | |||
Linear Mode
