Hi,

Advice / help /code would be greatly appreciated.

I need to figure out how to assign the name of a worksheet to
variable. My situation is:
I have an combo box containing a list of year's, when a year i
selected a new worksheet is created and renamed to the year selected.
userform containing inputboxes is then used to enter dates onto the ne
sheet.

I need to figure out a way of ensuring only certain dates are entere
into certain sheets. (eg Only dates in 2005 can be entered into th
2005 sheet, etc etc)

The only way I have thought of doing this, (before the code fires tha
enters the dates onto the sheet) is to compare whatever date the use
wants to enter (in the form of the inputbox) against the name of th
spreadheet, I dont know how to do this, I assume that the workshee
name has be assigned to a variable before this can happen?

I would really appreciate any input /help.
Thanks
Be

--
benjammin
-----------------------------------------------------------------------
benjammind's Profile: http://www.excelforum.com/member.php...fo&userid=1821
View this thread: http://www.excelforum.com/showthread.php?threadid=38487