Dynamically Switch Worksheets Based On Selection Made From A Combobox

Hello,
I want to avoid writing more lines. That is, I want to avoid the multiple case statements.

And I am looking for a way to dynamically determine the two sheets to send data to, based on the selection from the combobox1, without using the case statement.

I have codes that I will run under the case statement – longer codes- and writing it three times will make my scripts too long. That is why I am looking for a way to get it written only once.

So when I make a selection from the combobox1, I want the code to point to the two right sheets.
For example, if the selected sheet is “Data 1” from the combobox1, then the two sheets to send data to are “Data 2” and “Data 3”.

I wish someone could help me out with the script to get the job done. Thanks in advance.

Please Login or Register  to view this content.

One way.
Load the relevant info to Combobox.

Please Login or Register  to view this content.

changed to code and eliminated command button

Please Login or Register  to view this content.

That's amazing. It worked like a charm!

Now that I know it's possible, what I was thinking, let's see if this is possible too:

A want to place a textbox on the userform and this time around, I am not sending any data to the sheets. But I am clearing contents from the sheets.

So when I click the command button, I want to find or locate the id from the textbox in the range A4:A24.

And when I find it, I want to clear the contents from the row on which the id is found.

I think you are asking completely different question now.

Mark the thread as "Solved" and open a new thread.