Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text for option buttons in message box
I have a macro that imports data into a workbook. The macro provides the
user with an option to either 'replace' the existing data with the new, or 'append' the new data to the bottom of the existing data. I have a message box that provides yes/no/cancel buttons, but ideally I would rather have the buttons say Replace/ Append/Cancel. Is there any way to alter the option button text in a message box? Is there something other than a message box that could be used to satisfy this need? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text for option buttons in message box
Hi JDaywalt
You must create a small userform if you want this Start here http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JDaywalt" wrote in message ... I have a macro that imports data into a workbook. The macro provides the user with an option to either 'replace' the existing data with the new, or 'append' the new data to the bottom of the existing data. I have a message box that provides yes/no/cancel buttons, but ideally I would rather have the buttons say Replace/ Append/Cancel. Is there any way to alter the option button text in a message box? Is there something other than a message box that could be used to satisfy this need? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Header & Footer Info w/ Worksheet Option Buttons | Excel Discussion (Misc queries) | |||
Formatting Text on Option buttons | Excel Discussion (Misc queries) | |||
cell message with option buttons | Excel Programming | |||
Want to get user selections from a message box using option buttons | Excel Discussion (Misc queries) | |||
Changing text size in option buttons on a userform | Excel Programming |