User Form and Select Case Help

Hey Guys...

I have created a user form where the user inputs sales data for certain locations. The data that is inputed is then displayed into certain worksheets depending on the values.

For example, the user form contains a combo box where user can select weeks 1 - 4, another combo box where he can select the location, a 'total revenue' txt box, 'gop' text box, and rooms sold text box.

depending on which week the user selects, i want the data to be input into that specified worksheet. For example, submitting data for week 2 at Hotel A, will input data into worksheet two and in the Hotel A row.

I tried using Select Case, but I am running into some problems.

I have attached the sample worksheet for your review.

Also, below is the code I have written so far. Help would be appreciated. Thanks!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello yusunghee:
I've made the following changes to your code
1) Selecting a week in the Week Drop down Immediately takes you to that sheet
2) Selecting a hotel Immediately highlights the hotels column AND fills the forms text fields with any values the specific Hotel has on the current week sheet
3) The Submit Button is greyed out until a valid Week and Hotel have been selected .. then it is enabled
4) Top of form module has been given variables for specific columns

With all this in mind here's you submit procedure ...

Please Login or Register  to view this content.

ATTENTION: This procedure only works when used in conjunction with a form that has all the changes I've made.. see attached file.