I am in the process of creating an excel add-in. As the default value for one of my form textboxes, I would like to use the excel active worksheet name. How do I go about accessing this information. I am set up to create new tabs sucessfully, but I am unable to locate any commands to access the active worksheet's name so that I can store it in a variable.

Can anyone give me some insight into this problem?

I am new at this and I have been given this project with very little instruction. Trial by fire.

Thanks,
snjdev