retrieving in a textbox

[foxster]

hi
i made a calendar with 13 sheets (general, janu...feb.......)
i made a form with a calender choise (via calendar10)
i chose a date and then i want to look up that date in the sheet with the same month and put in a texbox something that is in the row besides the date...

i'm working on it...but no results....who can point out the way????

thx
foxster:dunno

[Jacob Hilderbrand]

Well you can get the month from the calendar like...


Mon = Format(Calendar1.Value,"mmmm")


That will get you to the sheet, then lookup the range you want and put that in the textbox...


TextBox1.Value = Range("A1").Text