UserForm to Trigger a specific sheet

[Excelnoub]

Good morning guys,
Having problems with UserForms. I have 5 sheets and I have msgbox with vbYesNo and sometimes also cancel. I am trying to change that to userforms as I will have to add more options to the selections and add more codes. I don’t play around UserForms that often but when I do it is for some simple things.

I want to change the following into a userform.

In my Sheet1 I have a drop down selection on Column N with Transfer "yes" and Cancelled "No". So that when a user selects “yes” it will do the following:

Please Login or Register  to view this content.

Sheets(“MERX”) is my sheet2

I need to have this in a UserForm. I already have a UserForm1 with a cmd button (cmd1). I don’t know how to modify this code to input it in a userform to trigger my sheet1 and not trigger every sheets. I need to have around 5 Userforms but each userform should trigger its own sheet.

Can someone help me get started? I have a lot of code to change in Userform and don’t know where to start.

Help would be much appreciated.

Thank you.

[Excelnoub]

I will post my workbook but it is a big file with alot of VB code...Well it is all VB codes upon request only. I will post one of my codes in one of my sheets for a better understanding.

Here is my Sheets("Pre-Requisition") sheet

Please Login or Register  to view this content.

[ag273n]

do you want the codes above to occur when you click a command button in your userform?

which sheet do you usually open first when you start your work with the workbook? or do you randomly open a sheet from that workbook to begin with?

[ag273n]

or if you want the sheet to open upon clicking something on the userform.. you can use the activate method...
thus...

Please Login or Register  to view this content.

the code above will focus or open the sheet you want..

[Excelnoub]

Any tab will be selected when the workbook is opened up. It all depends on which tab was save upon exiting.

Don't get me wrong, my workbook works like a charm but it would be better if the selections were made through forms, because I may have to more options in the transfers. Each sheet would have its own userform with options.

Plus I am thinking of making a userform to add the first selection on the main sheet.

The reason why is that I have another workbook that I have built, very simple, that uses UserForms and I find it better for myself and for the users.

[Excelnoub]

Found my answer, and my workbook is now Userform...

Thank you all.