My understanding of vb is not very good.


If ActiveCell.Column = t Then ActiveCell.Offset(0, -1).Text = "25"
else ActiveCell.Offset(0, 1).Text = "25"


I have a button between two columns in the center of the screen. I want
the user the to select a cell from one of the two columns, then select
from one of the buttons in between the columns that will assign a value
to the cell on the outside of each column.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=519085