I am try to make a user form where people can enter thier work schedul
(what days they work).

The format I am trying to reproduce looks like 'this
(http://www.timeanddate.com/calendar/).

The way I have it setup there is a spin button which determines whic
is the current month and then I have 35 labels and textboxes setup in
matrix similart to this:

1 2 3 4 5 6 7
[] [] [] [] [] [] []

8 9 10 11 12 13 14
[] [] [] [] [] [] []

15 16 17 18 19 20 21
[] [] [] [] [] [] []

22 23 24 25 26 27 28
[] [] [] [] [] [] []

29 30 31 32 33 34 35
[] [] [] [] [] [] []

What I want to do is, adjust this for the current month.

For instance, if the current month was September of 2004 then I woul
hide labels and textboxes 1, 2, 3, as well as 34 and 35 by changin
thier 'visible' property to false. I would then rename the remainin
labels/textboxes to reflect the appropriate dates.

The only sane way I can think of doing this is by putting all th
elements in an array and then hide and rename things in a for loo
where appropriate.

Thanks ahead of time

--
Message posted from http://www.ExcelForum.com