View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Proprietary text on popup buttons


Hi All

This is part of a macro I use :


Response = MsgBox("Click Yes to ship internationally. No to ship to UK
only", vbYesNo, "Ship Internationally?")

If Response = vbYes Then GoTo jumpover

Range("L2").Select
ActiveCell.FormulaR1C1 = "3"
Range("L2").Select
Range("L2:L" & lrow).Select
Selection.FillDown
Range("L2").Select

jumpover:


The text on the buttons says respectively 'Yes' and 'No' , of course.

Is there a way to rearrange this to perform the same function , but have
'International' and 'UK' on the buttons?

Grateful for any advice.



Best Wishes