Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save TextBox Entry after WorkBook is closed
Hello to all
I've got a problem with recovering textbox entries in a Userform after the workbook is closed. I found the following code (from Tom Ogilvy), which works perfectly when the Userform is closed, but it doesn't work if I close and re-open the workbook. Ideally, I would like to store (somewhere) the values that I enter in the textboxes and use them after closing the specific workbook and opening it at another point in time. ======<General Module ===== Public sString As String ======<Userform Module===== Private Sub CommandButton1_Click() sString = TextBox1.Text Unload Me End Sub Private Sub UserForm_Initialize() If Len(sString) 0 Then TextBox1.Text = sString Else TextBox1.Text = "" End If End Sub Can anybody help me with this one? Many thanks in advance. AP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save TextBox Entry after WorkBook is closed
Try this
Private Sub UserForm_Initialize() TextBox1.Text =Worksheets("Sheet1").Range("A1").Value End Sub Private Sub UserForm_Terminate() Worksheets("Sheet1").Range("A1").Value = TextBox1.Text End Sub change the worksheet area to suit. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "wpllc2004" wrote in message om... Hello to all I've got a problem with recovering textbox entries in a Userform after the workbook is closed. I found the following code (from Tom Ogilvy), which works perfectly when the Userform is closed, but it doesn't work if I close and re-open the workbook. Ideally, I would like to store (somewhere) the values that I enter in the textboxes and use them after closing the specific workbook and opening it at another point in time. ======<General Module ===== Public sString As String ======<Userform Module===== Private Sub CommandButton1_Click() sString = TextBox1.Text Unload Me End Sub Private Sub UserForm_Initialize() If Len(sString) 0 Then TextBox1.Text = sString Else TextBox1.Text = "" End If End Sub Can anybody help me with this one? Many thanks in advance. AP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I recover an excel file I closed and did not save | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Validating Entry into Textbox | Excel Programming | |||
restrict entry in a textbox to a range of values | Excel Programming | |||
Highlighting or Selecting TextBox entry | Excel Programming |