Sleeper: How Do I Get My Own Forum Here???

thanks Xld.
I may not have explained myself clearly. What I would like to do is have say E3 display the 1st E4 Display the 2nd etc.

Code:

---

If Range("f2").Value = "Jan" Then UserForm1.Calendar1.Month = (1)
If Range("f2").Value = "Feb" Then UserForm1.Calendar1.Month = (2)
If Range("f2").Value = "Mar" Then UserForm1.Calendar1.Month = (3)
If Range("f2").Value = "Apr" Then UserForm1.Calendar1.Month = (4)
If Range("f2").Value = "May" Then UserForm1.Calendar1.Month = (5)
If Range("f2").Value = "Jun" Then UserForm1.Calendar1.Month = (6)
If Range("f2").Value = "Jul" Then UserForm1.Calendar1.Month = (7)
If Range("f2").Value = "Aug" Then UserForm1.Calendar1.Month = (8)
If Range("f2").Value = "Sep" Then UserForm1.Calendar1.Month = (9)
If Range("f2").Value = "Oct" Then UserForm1.Calendar1.Month = (10)
If Range("f2").Value = "Nov" Then UserForm1.Calendar1.Month = (11)
If Range("f2").Value = "Dec" Then UserForm1.Calendar1.Month = (12)
UserForm1.Calendar1.Year = Range("h2").Value
'For x = 1 To 42
'Range("c4:i9").Value = UserForm1.Calendar1.Day(x)
'Next
End Sub

---

I have put a list into each of the cells and can change the Calendar to the Month and Year there may be an easier way to do it. However this works. Now I would like to have the other cells display the days and update if Month and year are changed.

It is very good the amount of help I am getting from all of you. However I was hoping other new people would get involved. If anyone who is new is watching what is going on here please don't hesitate to jump in.

I am at a loss as to why you would need a Userform, it now seems to me that you are creating a calendar in a worksheet range?

Is this the sort of thing that you want?

Xld. Yes that is similar to what I want. As to why I need a userform I don't know. Originally I said a form or a work sheet. You suggested I get the Add in I presumed you were going to do it from that. My mistake sorry.

Quote:

---

Originally Posted by peterwmartin

Xld. Yes that is similar to what I want. As to why I need a userform I don't know. Originally I said a form or a work sheet. You suggested I get the Add in I presumed you were going to do it from that. My mistake sorry.

---

What I said was to use the calendar control, and pointed you at that site in case you didn't have it. I hadn't been there for a while, and had forgotten that he also has an add-in. Should have pointed you at Ron de Bruin's site, he has an example using it from a worksheet, tried to cut out the middle-man :)

Ok so I got a little lost. Shaken but not defeated.
Can we go back and try how would I go about filling a range of say 6 columns and 6 rows with the days of a month.

Mine's 6x8, but is this the sort of thing that you mean

Yes thank you xld.
I am trying to look through it to see how you have done it. It does not seem to have any code. So I presume it is done from the formula bar alone. If so I need to learn a lot more about excel itself.

It is all formulae. They are quite straight-forward, but just fire questions if you want any explanations.

Hi Peter
Did you see this post?
http://www.vbaexpress.com/forum/showthread.php?t=11013

Quote:

---

Originally Posted by xld

Mine's 6x8, but is this the sort of thing that you mean

---

Very neat Bob
:clap::clap::clap:

You so far have sent me from vba to what you call straight forward excel formulae. I fear with this question you might send me back further. Maybe high school math.
Some of your functions in the formula bar have (TODAY())) I understand that if you open brackets you need to close them. Could you write that as (TODAY)))( or would this change the result. Also could you just close them all at the end?
It's so long since I went to school I hope that is high school math. If it is back before high school. This is going to hurt!

mdmackillop. Sorry I was typing my response to xld and you slipped in two new ones. Yes I have downloaded it and did see Ausiebears thread.
However I have been busy here. I will have a look at it now. If I have any questions I will add them to Aussiebears thread.
Thank you for your help.

=Today() is a function which requires the empty brackets as shown. The whole can be enclosed in outer brackets and used in calculations
eg =INT(TODAY()/7)*7

Thanks md I knew that. I guess it was the function that xld had looked a bit confussing and I lost it. I guess I need to just break it down into little bits.
Thank you
I also went back to the other calendar. A bit beyond basic I might try and work through the one xld sent me and try and understand what it's doing first.

Quote:

---

Originally Posted by peterwmartin

You so far have sent me from vba to what you call straight forward excel formulae. I fear with this question you might send me back further. Maybe high school math.
Some of your functions in the formula bar have (TODAY())) I understand that if you open brackets you need to close them. Could you write that as (TODAY)))( or would this change the result. Also could you just close them all at the end?
It's so long since I went to school I hope that is high school math. If it is back before high school. This is going to hurt!

---

Every opening bracket must have a corresponding closing bracket, the trick is getting it in the correct place.

TODAY() is a bult-in function, and as all functions have the ability to define arguments, the () is used to enclose the arguments. Even functions that have no arguments, such as TODAY() still have to follow the syntax rules, so you see an emptys et of parentheses.

If you add a mis-matched bracket, it will certainly error. In your example it will error because the function is not followed by an opening bracket.

BTW, there is an opening bracket before TODAY() and a closing one after it because I am using another function, YEAR(), upon it to get this year number to dynamically build up the dates. YEAR(), unlike TODAY(), does have an argument, a date, so TODAY() returns a date, and YEAR(TODAY()) gets the year of that date.

ANother point, I am using conditional formatting to pick out today's date, and to clear the Sat and Sun cells not in this month.

Xld cell H3 has this formula

Code:

---

=IF(COLUMN()=2,N2+1,G3+1)

---

I am totally lost with the N2 is it a cell reference.

Xld Sorry I found the answer to that. Trying to copy an paste all the cell formulae to notepad to print and look at all together.

Peter,

You can use the CTRL button with the tilde key (just left of the 1 key along the top row of numbers) to display formulas in Excel. Of course, you will need to adjust column width to see them. If you select the range and format with word wrap you will be able to adjust the row height and then print out all the formulas to review.

Regards,