Hello all,

here is stage 2 of the complex userform!
(WARNING this one is tough!!)

i have a userform that has a combobox at the top of the
page, this combobox can select a date that appears within
the table already or it can have a new date typed in.

**update**
if the combobox has had a date selected then i would like
the following to be updated....
1) 6 textboxes along the left hand side of the userform
that contain times need to be found from the sheet ( these
are found in column "AY" )
** the condition so far is that the time "AY" musat be
from rows that contain the date "AX" from combobox1**
one time is found in 2 rows therefore it only needs to be
input once into each textbox EVEN THOUGH there are two
records that contain this.

**new date**
if a new date is typed in then the textboxes can stay the
same and allow the user to input there specified time slots
((NO ACTION NEEDS TO BE TAKEN ON NEW DATE))

thank you,

Robert Couchman

Robert,
Assuming your cbo.style = 0 (frmStyledropDownCombo), the change event will
fire when a new date is entered, whereas the click event will if something
is selected from the list.
Apply you logic to the suitable event, using something like VLOOKUP I would
guess.

NickHK


"Robert Couchman" wrote in message
...
Hello all,

here is stage 2 of the complex userform!
(WARNING this one is tough!!)

i have a userform that has a combobox at the top of the
page, this combobox can select a date that appears within
the table already or it can have a new date typed in.

**update**
if the combobox has had a date selected then i would like
the following to be updated....
1) 6 textboxes along the left hand side of the userform
that contain times need to be found from the sheet ( these
are found in column "AY" )
** the condition so far is that the time "AY" musat be
from rows that contain the date "AX" from combobox1**
one time is found in 2 rows therefore it only needs to be
input once into each textbox EVEN THOUGH there are two
records that contain this.

**new date**
if a new date is typed in then the textboxes can stay the
same and allow the user to input there specified time slots
((NO ACTION NEEDS TO BE TAKEN ON NEW DATE))

thank you,

Robert Couchman