Force user to fil up certain cell based on values of another?

[PATSYS]

Hi all,

I have a worksshet wherein the user chooses a value from a dropdown in column V.

Column AB (of the same row) has a formula that calculates based on the value in column V.

Now I would like that it the value in column AB is either "X1" or "X2", that column AX be selected and that usr can not move to antoher cell unless this cell is filled up.

Appreciate your help.

Thanks

 

[PATSYS]

Hi all,

I have a worksheet wherein the user chooses a value from a dropdown in column V.

Column AB (of the same row) has a formula that calculates based on the value in column V.

Now I would like that if the value in column AB is either "X1" or "X2", that column AX be automatically selected and that user can not move to another cell unless this cell (column AX of the same row) is filled up.

Appreciate your help.

Thanks

Hi all,

I have partly editted above post for few typos.

Anybody here who knows how to do above?

Rgds

 

[Marcelo Branco]

Hi,

Maybe something like this

Private Sub Worksheet_Change(ByVal Target As Range)
 
    If Not Intersect(Target, Range("V:V")) Is Nothing Then
        If Cells(Target.Row, "AB") = "X1" Or Cells(Target.Row, "AB") = "X2" Then
            Cells(Target.Row, "AX").Select
            Do While Selection = ""
                  Selection = Application. _
                  InputBox("Enter with a value in " & Cells(Target.Row, "AX").Address(False, False) _
                  , Type:=2)
                  If Selection = False Then Selection = ""
            Loop
        End If
    End If
 
End Sub

User must enter a string (Type:=2). If you want another type adjust it.

HTH

M.

 

[PATSYS]

Thanks Marcelo.

Would it be possible to take out the input box and instead cell AX is selected and that the user can not leave that cell (i.e. AX) until it is filled up with value?

Rgds