Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation window once user clicks submit on user from
Hi All, I have designed an excel from with text fields, radio buttons and check boxes. I also have a Submit button that populates the user details in excel sheet. What I want is: Is it possible to display a confirmation window with user inputs once a user clicks "Submit" button on the original form? Confirmation window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to the original form if "Edit" is clicked or the user inputs are populated into the excel sheet if "Confirm & Submit" is clicked. Thanks in Advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation window once user clicks submit on user from
Yes, make another form with these buttons on it. Make sure the original Submit button doesn't include Unload Me (which makes the first form forget everything) but uses Me.Hide before opening the second form. The Edit button in the second form can then use Form1.Show and you'll see the first form as it was just before you clicked Submit (you would probably use Unload Me from the second form as there's nothing there to remember). Hope that makes sense. "sam" wrote: Hi All, I have designed an excel from with text fields, radio buttons and check boxes. I also have a Submit button that populates the user details in excel sheet. What I want is: Is it possible to display a confirmation window with user inputs once a user clicks "Submit" button on the original form? Confirmation window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to the original form if "Edit" is clicked or the user inputs are populated into the excel sheet if "Confirm & Submit" is clicked. Thanks in Advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation window once user clicks submit on user from
Yes, make another form with these buttons on it. Make sure the original Submit button doesn't include Unload Me (which makes the first form forget everything) but uses Me.Hide before opening the second form. The Edit button in the second form can then use Form1.Show and you'll see the first form as it was just before you clicked Submit (you would probably use Unload Me from the second form as there's nothing there to remember). Hope that makes sense. "sam" wrote: Hi All, I have designed an excel from with text fields, radio buttons and check boxes. I also have a Submit button that populates the user details in excel sheet. What I want is: Is it possible to display a confirmation window with user inputs once a user clicks "Submit" button on the original form? Confirmation window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to the original form if "Edit" is clicked or the user inputs are populated into the excel sheet if "Confirm & Submit" is clicked. Thanks in Advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation window once user clicks submit on user from
Thaks for the Help Smallweed, Should I code into Submit_Click() event in the original form to launch the second form with 'Edit' and 'Confirm and submit' buttons? If yes, How can I code it such that It launches the second userform. I am not as good with VB. Also Its ok if the user inputs are not displayed in the new form, Just a confirmation window with 'Edit' button(navigate back to original form with data populated) and 'Confirm and Submit' button (saves the inputs) should be fine Thanks in Advance. "Smallweed" wrote: Yes, make another form with these buttons on it. Make sure the original Submit button doesn't include Unload Me (which makes the first form forget everything) but uses Me.Hide before opening the second form. The Edit button in the second form can then use Form1.Show and you'll see the first form as it was just before you clicked Submit (you would probably use Unload Me from the second form as there's nothing there to remember). Hope that makes sense. "sam" wrote: Hi All, I have designed an excel from with text fields, radio buttons and check boxes. I also have a Submit button that populates the user details in excel sheet. What I want is: Is it possible to display a confirmation window with user inputs once a user clicks "Submit" button on the original form? Confirmation window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to the original form if "Edit" is clicked or the user inputs are populated into the excel sheet if "Confirm & Submit" is clicked. Thanks in Advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation window once user clicks submit on user from
(I'm having problems with this forum today so apologies if there are suddenly a load of duplicate messages from me!) I've suddenly thought: I'm assuming you are creating a UserForm from Insert menu in VB Editor (rather than a form in the s/sheet itself). If so, the button code in Form1 should be: Sub Submit_Click() Form2.Show Me.Hide End Sub Then you make a second UserForm called Form2 with your 'Edit' and 'Confirm and submit' buttons. Then: Sub Edit_Click() Form1.Show Unload Me End Sub Sub Confirm_and_Submit_Click() (your code) Unload Me End Sub "sam" wrote: Thaks for the Help Smallweed, Should I code into Submit_Click() event in the original form to launch the second form with 'Edit' and 'Confirm and submit' buttons? If yes, How can I code it such that It launches the second userform. I am not as good with VB. Also Its ok if the user inputs are not displayed in the new form, Just a confirmation window with 'Edit' button(navigate back to original form with data populated) and 'Confirm and Submit' button (saves the inputs) should be fine Thanks in Advance. "Smallweed" wrote: Yes, make another form with these buttons on it. Make sure the original Submit button doesn't include Unload Me (which makes the first form forget everything) but uses Me.Hide before opening the second form. The Edit button in the second form can then use Form1.Show and you'll see the first form as it was just before you clicked Submit (you would probably use Unload Me from the second form as there's nothing there to remember). Hope that makes sense. "sam" wrote: Hi All, I have designed an excel from with text fields, radio buttons and check boxes. I also have a Submit button that populates the user details in excel sheet. What I want is: Is it possible to display a confirmation window with user inputs once a user clicks "Submit" button on the original form? Confirmation window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to the original form if "Edit" is clicked or the user inputs are populated into the excel sheet if "Confirm & Submit" is clicked. Thanks in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pause While User Clicks on Chart Series | Excel Programming | |||
Pause while user clicks on chart series | Excel Programming | |||
How to have errr msg pop up when user clicks on locked cell | Excel Discussion (Misc queries) | |||
Counter for user clicks | Excel Programming | |||
Submit User Form Contents to next available row | Excel Programming |