Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi There,
I would like to get in my textbox the value of a certain cell on my sheet ... If i do not like the value ...I fill in Textbox1 and write it to the same cell Could it be that it unloads ...? Sub Fill_Form() Dim pform As UserForm4 Set pform = New UserForm4 Application.ScreenUpdating = False Load pform pform.Show If bStop Then Exit Sub '***** TO SUGGEST WHAT IS ALREADY FILLED IN THE FILE ***** pform.TextBox1.Value = Worksheets("General TT").Range("C3").Text '***** To OVER-WRITE EXISTING DATA **** Worksheets("General TT").Range("C3") = pform.TextBox1.Text Application.ScreenUpdating = True 'Run "Save_CCard_Proposed_Name" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unloading UserForm not working | Excel Programming | |||
Not Unloading a UserForm | Excel Programming | |||
Unloading User Forms? | Excel Programming | |||
Unloading A Form | Excel Programming | |||
Unloading an Add-In | Excel Programming |