Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 233
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have the below code that when it runs updatea 14 tables, wondering how can I show a msg using the text boxes in the template below showing whether the subs end successfully or not.
I have the below code that when it runs updatea 14 tables, wondering how can I show a msg using the text boxes in the template below showing whether the subs end successfully or not.
VBA Code:
Private Sub Command0_Click()
'Sub 1
A_Forecast
'Text box showing the msg OK or failed
A_ForecastTxt "OK" or "Failed"
'Sub 2
B_Forecast
'Text box showing the msg OK or failed
B_ForecastTxt "OK" or "Failed"
.
.
.
Sub14..
End Sub