I am trying to write a conditional statement that will allow the users to
enter a value in only one cell. I created a function and am calling it from
the worksheet.
Function onChange()
Dim x As Integer
Dim y As Integer
x = ActiveCell.Row
y = ActiveCell.Column
If Cells(x, 1).Value < "" Then ' checks to make sure selected row
contains an Item
If y = 8 Then
If y <= 10 Then
Cells(x, 8).Value = ""
Cells(x, 9).Value = ""
Cells(x, 10).Value = ""
End If
End If
End If
End Function
I am trying to make sure that only 1 of these cells can contain a value.
I called this function on the double click event. It works great... except
the user can use the arrow key or single click to leave the cell that was
double clicked or simply enter any of the cells using arrow key or single
click, thus rendering my coade useless. I need to find a way to ensure that
if they leave one of these cells that this code will still run. The users
could add records on any of the sheets so I have to keep my code generic.
Meaning the rows may change but the column indexes will always be the same.
I took Visual Basic in college for VB.Net. Trying to wrap my mind around VBA
is killing me. Does anyone have any suggestions?