This is one way to do it. I'm assuming you want the cell to move down a
row each time to keep track? If not, then you can just take out the
Do/Loop and the second If/Then statement.

If cboList.Value = "Close" Then
rCell = 3 'This is the row number
cCell = 7 'This is the column number
Do
If Cells(rCell, cCell).Value < "" Then
rCell = rCell + 1
End If
Loop Until Cells(rCell, cCell).Value = ""
Cells(rCell, cCell).Value = "=Now()"
Cells(rCell, cCell).Activate
ActiveCell.Copy
ActiveCell.PasteSpecial (xlPasteValues)
End If

Where "cboList" is whatever you named your ComboBox.
Hope that helps.

-Ikaabod

afmullane Wrote:
Hi guys,

I am trying to make a cell in a column populate when i select the third
option from a drop down box within another field. I have been trying to
use an If statement but with little success. Basically when the user
selects Close from a drop down box the current system time will
populate in the time closed column.

Any help would be greatly appreciated,

Aidan Mullane


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534314