Message Box and User Input in VBA

[sax2play]

Good Morning All,

I have a dynamic drop down list in cell N7. The cell is blank at the start of the macro, and then I need the user to select an option from the drop down list during the macro. The macro is set to prompt the user to make a selection; however the user cannot make the selection until pressing "OK" at which point the macro checks whether field N7 has text and ends the routine. How do I pause the macro to allow the user to make a selection from the drop down before checking whether N7 is blank and displaying the message box again or proceeding with the routine?

Thanks!

 

[ranman256]

Exit the macro after telling the user to pick an item.
If the drop box is good, then the macro continues:

sub MyMacro()
if cboBox  ="" then
   msgbox "You must choose an item"
   exit sub
endif

'run the full macro here...

end sub