Click event moves user to column W

I have a combo box that I have created.

When one of my users pulls the drop down to place an item into a cell, how
do I tell the Click Event to move the person's cursor to column W (or C23)
before placing the item they chose?

Here is my current vb code:

Private Sub ComboBoxForemen_Click()
ActiveCell.Value = ComboBoxForemen.Value
ComboBoxForemen.Value = "Foremen List"
ActiveCell.Select
ActiveCell.Offset(1, 0).Select
End Sub

Thanks so much. Tofer

This will move it to column "W":

Private Sub ComboBoxForemen_Click()
myCell = "W" & ActiveCell.Row
Range(myCell).Value = ComboBoxForemen.Value
ComboBoxForemen.Value = "Foremen List"
ActiveCell.Offset(1, 0).Select
End Sub


Hope that helps.

Ikaabod,

That solved it!

Thanks ever so much.

Tofer

"Ikaabod" wrote:

>
> This will move it to column "W":
>
> Private Sub ComboBoxForemen_Click()
> myCell = "W" & ActiveCell.Row
> Range(myCell).Value = ComboBoxForemen.Value
> ComboBoxForemen.Value = "Foremen List"
> ActiveCell.Offset(1, 0).Select
> End Sub
>
>
> Hope that helps.
>
>
> --
> Ikaabod
> ------------------------------------------------------------------------
> Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
> View this thread: http://www.excelforum.com/showthread...hreadid=534923
>
>