View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 1st and last date of the month from MonthName

you don't mention how you get the month names into the combobox
this is a simple overview:

i would probably use a rowsource from a sheet with the first day of each month
in a cell

something like Sheet3!A1:a12

then fill and format the combobox with the month name

then textbox 1 could be the value from sheet3!a1
and text box 2 could be this formula
=EOMONTH(A1+1, 0)

or

=EOMONTH(me.textbox1.value +1, 0)






--


Gary


"Abdul" wrote in message
ups.com...
Hello!,

How I could get the starting and ending date of a month based on month
name.

For Eg. say I have combobox1 and textbox1 and textbox2. If i select
january from combobox1 i want to get 1/1/2006 in textbox1 and 31/1/2006
in textbox2 ..

thanks