Save my internship

[DNiersbach]

Hey guys I'm new here and this is my first post.

I'm trying to write a macro that will enter data into a worksheet based on the values entered in the form. I've created the user form but the coding is giving me issues.

I'm trying to write a function that will activate the sheet matching the first two inputs before entering the rest of the data in the sheet.

For example,

B1=7/1/15 and C1=Name

How do I get the macro to activate sheet "Name 07-15" my matching the above cells?

Thank you!

 

[ndsutherland]

In the vba window, go to view and activate the immediate window. That will show your debug.print

 

[Smitty]

Your earlier code works fine. This one won't do anything since you're no longer referencing sname.

What I mean by "The sname string and worksheet name need to be identical" is that whatever string the sname variable returns must exactly match the sheet name that you're trying to reference.

Let's say you have "John" in F1 and "07-15" in B1, giving you "John 07-15", but the sheet name is "John Doe 07-15", then the code will fail since there's no match. Hence the subscript out of range error, which means that Excel can't find the sheet name that you're trying to reference.