Thread: pause macro until user selects correct range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default pause macro until user selects correct range
hi JCIrish

Check out

Application.InputBox in the VBA help with Type:=8




--
Regards Ron de Bruin
http://www.rondebruin.nl


"JCIrish" wrote in message ...
Within an event handler for a worksheet command button I display a msgBox
telling user to select a specific cell. When user clicks OK on the msgbox
how do I pause the macro until he selects the correct cell?


Reply With QuoteReply With Quote