UserForm with "Cancel" and "Proceed" buttons

Hi all,
I stuck with an issue in an input box before an excel file gets opened.
User can optionally enter a number code into a field, which then will be added to the file name.
This works as intended.
Now I wanted to fine tune the whole thing a bit.

I have two buttons "Cancel" (CommandButton1) and "Proceed" (CommandButton2) on my userform

Now I want the cancel button to simply cancel the main macro, end / exit the sub and go back to the origin excel sheet.
This works well.

BUT
The Proceed button which is supposed to continue with the rest of the macro, either with a value in the input field or without, does not do what I want it to do :-)

Either the proceed button also goes back to the origin excelsheet or the cancel button also proceeds with the main macro to browse for a file .

See screenshot of the UserForm, the code behind it and the main macro code
Macro_Cancel_Proceed.JPG

Thanks upfront for your help

Why don't you make code that will call your UserForm with Cancel and Processed buttons (outside your main macro).
Then you could define your needs in CommandButton1_Click and CommandButton2_Click. If Cancel wiil be pressed - nothing will happen. If Proceed will be pressed - main macro will start.
Lets say you start with this sub

Please Login or Register  to view this content.

Then write code for two buttons:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Kasan
hmm, not sure I do understand that.
I have already a button on the main excel sheet, which opens the main macro.
OpenExcelsheet.JPG
Upon clicking on this button, the UserForm1 gets opened

Code within the main macro:
UserForm1.Show 1

ActiveSheet.Range("g3").Value = UserForm1.TextBox1
Unload UserForm1

But user should be able to either cancel the whole task, or to proceed to open the windows explorer, (no matter whether they did put in a code in the TextBox1 or not) and to browse for the file they need

Am I missing something?

Now your main macro show userform, but yiu could remove this part from main macro and show user form from separete small macro. Then if you press one button - your main macro will start. You can bind your button on a sheet to run macro that will only show userform.

oh - ok. Will try this
Thanks!!!