PDA

View Full Version : Excel User Form Inquiry



bassman71
09-07-2006, 03:34 PM
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.....:banghead:

Bob Phillips
09-07-2006, 04:19 PM
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.....:banghead:



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

Zack Barresse
09-08-2006, 09:09 AM
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 ...

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

HTH