Excel User Form Inquiry

[bassman71]

Hello,

I want the text typed into a form to populate a specific cell. In the code window, I thought to type something like...

[VBA]Private Sub TextBox1()
Workbook("Account holder!C9).value
End Sub[/VBA]


I'm not used to forms and as such don't know how to translate data to cells.

Thanks.....

[Bob Phillips]

Hello,

I want the text typed into a form to populate a specific cell. In the code window, I thought to type something like...

Private Sub TextBox1()
Workbook("Account holder!C9).value
End Sub


I'm not used to forms and as such don't know how to translate data to cells.

Thanks.....

[vba]

Private Sub TextBox1_Change()
Worksheets("Account holder").Range("C9").value = Me.TextBox1.Value
End Sub
[/vba]

[Zack Barresse]

Also, have you checked, at this point in your code, if that workbook is indeed open? You may want to think about checking with a simple function ...

[vba]Function WbOpen(wbName as string) as boolean
on error resume next
wbopen = len(workbooks(wbname).name)
End Function[/vba]

HTH