View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
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


Use a userform!!!??<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion