List Box Item To Dialog Box - Help Please

[snuggles79]

I have created a userform for work using Excel.

On clicking the command button I need a box to pop up saying "Are you sure that [List Box Value] is the option you want? " If no then the user just goes back to the form to change the value and if yes then to continue with the macros

How can I do this please?

Many thanks

 

[rjp]

Try this and let me know if you hit any trouble:

    'Assuming your ListBox is called lstTest
    Dim msgText As String
    Dim msgResponse As Integer

    msgText = "Are you sure that " & LstTest.List(LstTest.ListIndex) & " is the option you want?"

    msgResponse = MsgBox(msgText, vbYesNo, "Put a title in here")

    If msgResponse = vbYes Then
        'Carry on with the code
    Else
        'It's up to you, maybe just Exit Sub?
    End If

LstTest.ListIndex returns the index number of the currently selected item.