P
pswanie
hey guys
we got a number of specials runing at once but they dont all start or end on
the same day. now i need a msg box to pop up when the workbook are opened
and tell the user what specials are currently running and when it started and
when its going to end.
so i guess i need a msg box to pop up with a label and below that three in
put boxes and a okay button. in the three boxes we can type a short
description of the specials and next to it when it start and next to that
when it ends.
on the page it self (called "inputpage") i need the discription in column c
down and column d will be the start date and column e the end date. and if
possible if the system can see when it ends and the day after it end delete
the entry. if the system cant see and delete a "expired" special i can work
with a delete button. so u pick/choose the one thats expired and hit delete.
i did not use userforms to much yet but are starting so if a userform will
do the trick thats cool to
thanx
happy 2008 to all
Phillip
we got a number of specials runing at once but they dont all start or end on
the same day. now i need a msg box to pop up when the workbook are opened
and tell the user what specials are currently running and when it started and
when its going to end.
so i guess i need a msg box to pop up with a label and below that three in
put boxes and a okay button. in the three boxes we can type a short
description of the specials and next to it when it start and next to that
when it ends.
on the page it self (called "inputpage") i need the discription in column c
down and column d will be the start date and column e the end date. and if
possible if the system can see when it ends and the day after it end delete
the entry. if the system cant see and delete a "expired" special i can work
with a delete button. so u pick/choose the one thats expired and hit delete.
i did not use userforms to much yet but are starting so if a userform will
do the trick thats cool to
thanx
happy 2008 to all
Phillip