Forum Home
Press F1
 
Thread ID: 56055 2005-03-26 01:27:00 Message Box VBA Dannz (1668) Press F1
Post ID Timestamp Content User
338150 2005-03-26 01:27:00 I have a message box like this


Msgbox("Do you want to setup the template for the new year",vbOkCancel,"House Competition Points")

how do i find out if the user has clicked Ok or Cancel


Excel 2000 (vb6)
Dannz (1668)
338151 2005-03-26 07:04:00 something like this (www.exceltip.com)

i.e. you assign the result of the MessageBox function to aa variable and then do tests on it.
gibler (49)
338152 2005-03-26 08:03:00 Thanks Dannz (1668)
1