Relative Content

Tag Archive for excelvbamsgbox

macro should run ahed if msg box is not triggered

I want my macro to continue if the yes no msg box is not triggered.
currently i have set a yes no msg box in my macro. for example if the value in cell A1 is more than 100 then the msg box pops up and says “the value is above 100, do you wish to continue?” if i press no it exits sub and if i press yes the rest of the code executes. cool everything works good, but the issue is, when the value in cell A1 is less than 100 and i run the macro, just nothing happens. i want the macro to continue also if the value in cell A1 is below 100.
thank you

VBA Message Box To Choose What XLA File To Attach

So we have a legacy spreadsheet that isn’t going anywhere anytime soon. I’ve maintained two of them because there are times when we need different code to import a job. Upon opening the sheet, it attaches either one called Shipper.xla or on the second sheet, Shipper_Project.xla.