Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |