Hi Lambs -

One approach would be to use the TopLeftCell and OffSet properties as
follows (modify the column offset to suit):

Private Sub ComboBox1_Change()
With Me.ComboBox1.TopLeftCell
.Offset(0, 5) = Application.UserName
.Offset(0, 6) = Date
End With
End Sub
--
Jay


"Lambs" wrote:

Hello,

Programming is not my forte, so apologies for stating the obvious.

I want to code so that on selecting an option in a combo box, the cell to
the right of the combo box returns the current user's name, and then the date
the next cell along.

I can see from other posts that there is an 'on change' routine. I want a
few of these boxes, however, so I'd like the code to be relative to the
particular box, rather than an absolute reference, which I'd have to keep
re-jigging. Is there a way to 'cheat', for instance by working off the 'tied'
cell which returns 1,2,3, etc., depending on which option is selected?

Many thanks,