Input box

[DougRobertson]

At present, I use Input Boxes with the usual 'Yes', 'No' and 'Cancel' buttons. They return either vbYes, vbNo, or vbCancel. Simple.

However, I'm trying to create a macro that will save the open workbook in one of two folder options - 'Folder A' or 'Folder B'. I'd like to use an Input Box similar to the 'Yes No Cancel' one, but with the 'Yes' button essentially being replaced with a 'Folder A' button, the 'No' button replaced with a 'Folder B' button, and the 'Cancel' button staying as is.

Is there an easy way to do this? And what would be returned for the clicking of the various buttons, as opposed to vbYes etc.?

Or do I need to start from scratch with a new UserForm?

Thanks,

~ Doug

 

[Sahak]

Hi Doug;

1. I dont know about border around the button but you can color the button
2. I think no
3. How i know it is possible In Microsoft Excel 7.0