MessageBox for 2 cells

[reeceb]

Greetings,

I have a spreadsheet that I want to display a MessageBox if a value in a cell changes. I am building a Cisco device configuration generator.

I have done some conditional formatting so if the device selection is a router then all cells relating to switches are invisible. Vice versa if the device selection is a switch (all related to routers are invisible).

The next (data validated) field is the device selection. I would like to display a MessageBox for the user to verify the IOS before proceeding. Ideally, I would like the messageBox to display the correct IOS version (lookup from an array), but would be happy with just a messagebox.

Can anyone help, please ?

Reece...

 

[AlphaFrog]

This will display a message when you make a change to cell A1

• Right-click on the sheet tab
• Select View Code in the pop-up menu
• Paste the code below in the VBA edit window
• Change the A1 (red) in the code to the cell that you want this to work on
  

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Target.Address(0, 0) = "[COLOR="Red"]A1[/COLOR]" Then
        If Target.Value <> "" Then
            'Lookup IOS somewhere
            'IOS = Application.WorksheetFunction.VLookup(Target.Value, Range("C:D"), 2, 0)
            MsgBox Prompt:="Please verify the IOS before proceeding. ", _
                   Buttons:=vbExclamation + vbOKOnly, _
                   Title:="Verify IOS"
        End If
    End If
        
End Sub

Not enough details to do the lookup portion of the code.

 

[reeceb]

Fantastic. Thanks heaps for your help. Makes it heaps easier when being assisted by very clever people.

Reece...