still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 814
- Office Version
- 365
- Platform
- Windows
Hi
I have a year of dates in A2:A400
I have events in some of the cells in B2:B400....(birthdays, anniversary's, etc)
If I use a formula to find today's date and put what is in B in cell F1
...maybe a vlookup of xlookup.....
that part I can do....
I can also make the year change to the current year around Jan 1, so that =today() will work
I'm wondering if I could have a userform open if:
it is today's date...and...
if F1 is not empty
I know how to make a userform and populate a list box with a row source
I dont know if i can have a userform open if a its today's date and the row source is NOT empty
I don't want a userform open with an empty list box, of a message saying "no event today"
mike
I have a year of dates in A2:A400
I have events in some of the cells in B2:B400....(birthdays, anniversary's, etc)
If I use a formula to find today's date and put what is in B in cell F1
...maybe a vlookup of xlookup.....
that part I can do....
I can also make the year change to the current year around Jan 1, so that =today() will work
I'm wondering if I could have a userform open if:
it is today's date...and...
if F1 is not empty
I know how to make a userform and populate a list box with a row source
I dont know if i can have a userform open if a its today's date and the row source is NOT empty
I don't want a userform open with an empty list box, of a message saying "no event today"
mike