Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get Popup Text help to work | Excel Programming | |||
Forms Buttons. Can you add a Comment to POPUP if the Mouse floats over it ? | Excel Programming | |||
Non-proprietary use of an Excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I display text in a (popup) window? | Excel Programming | |||
proprietary protection | Excel Programming |