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? |
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? |
All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com