Hi all,

I'm new to the advanced features of Excel and have run into a fe
problems on a project I'm working on.

What I have:

A clip-art image with a macro that will call a calendar when the imag
is clicked on.

The way it works:

the active cell is filled in with the selected date

What I want:

A macro that will point the output of the calendar date to a specifi
cell. And if that cell has any data in it at all, seek out the nex
available cell below it and enter the data there instead.

What I have tried:

I tried to write a macro that would make the active cell a particula
cell when the clipart image was clicked. This didn't work at all, bu
probably because I'm a newb. If I can get this to work, I can the
tackle trying to make the macro check to see if the field is empty o
not, and pointing to the next cell below if it is not empty.

Misc info: The list of dates entered should not exceed 20 entries o
so, so I don't think it will be a problem with excel spending a lon
time seeking the next empty field.


Thank you for any help you can give! THis has been driving me nuts

--
Ouk
-----------------------------------------------------------------------
Ouka's Profile: http://www.excelforum.com/member.php...fo&userid=2398
View this thread: http://www.excelforum.com/showthread.php?threadid=37607