ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2000 macro Assistant.NewBalloon (https://www.excelbanter.com/excel-programming/322958-excel-2000-macro-assistant-newballoon.html)

ItascaCP

Excel 2000 macro Assistant.NewBalloon
 
Visual Basic Macro was previously working, now returnValue = .Show always = 0

With Assistant.NewBalloon 'Ask Processing year
.Heading = "Mainline Processing"
.Text = "Select the year to process"
.CheckBoxes(1).Text = Previous_yyyy_string
.CheckBoxes(2).Text = Current_yyyy_string
.CheckBoxes(3).Text = Next_yyyy_string
.Button = msoButtonSetOkCancel

returnValue = .Show


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com