I'm really rusty on my VBA and this is really simple, but I can't seem to get it to work. I'm trying to create a database in excel. Basically I have a data entry form and one part allows you 4 options. The sheet that the data is entered in depends on which option you choose. So if you choose the first, the data enters into sheet 1 when you press submit. I just can't get this to work for some reason.