Code to Activate a sheet 1 [IF] Userform box is "X" if not Activate Sheet 2

[Invicta084]

Hi, I need some help here, I'm having a rough time with this one. I have a userform to input data into a table and I'm trying to make it run on a certain sheet (Sheet 1) if the userform text box value is "X" and a different sheet (Sheet 2) if its "Y" I have two different scripts of data to input depending on what the text box says. Thanks for the help.

[mehmetcik]

UNTESTED CODE
Assumes you are using a command button to start your macro.

Please Login or Register  to view this content.

[Invicta084]

Just tried that in the code and it is not working, it doesn't give me any compilation errors but the code just does not do anything. I can post my code if it will help.

[mehmetcik]

Post Your Spreadsheet.

The code above is not practical it just shows you the method to use.

[Invicta084]

Understood. I just tried to implement the syntax you used to no avail. Below is a test spreadsheet.

[mehmetcik]

1. Where is the code that I am looking for.

2. I modified some of your code, why dosn't it work in your userform?

Please Login or Register  to view this content.

3. After a while I found it a pain to name my textboxes and checkboxes.
If you leave their names alone then you can use loops to fill and save them.

http://www.excelforum.com/excel-prog...ml#post3566034

[Invicta084]

1. The code in question is the submitform_click() code to fill the user form information into the excel sheet. It's the code attached to the user form submit button.

2. That is good to know for the future. All the companies and divisions are named different I just desensitised it to post it without getting in trouble. The issue I'm having with the code is that when I submit the form the code seems to do nothing but also does not provide me with an error code.

3. That is a good tip thanks.

[Invicta084]

Hey Mehmetcik, wondering if you were able to get that to work? I still have not been able to figure out how to correctly format the of statement to activate the sheet based on a input control criteria.