Hi,

for ComboBox change
Condition 1: if old content = new selected ComboxBox.item - do
nothing
Condition 2: if old content < new selected ComboxBox.item - change
content and .offset(1,0) = now()

How can I do this?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=543920

Use the click event. Maintain a static variable that holds the old/previous
value (which you will update).

--
Regards,
Tom Ogilvy

"gabch" wrote in
message ...

Hi,

for ComboBox change
Condition 1: if old content = new selected ComboxBox.item - do
nothing
Condition 2: if old content < new selected ComboxBox.item - change
content and .offset(1,0) = now()

How can I do this?


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=543920