I want to put a temporary userform in my code. So when my code starts,
I want small a message box which comes up with three option buttons. I
want the user to be able to click the option of choice and press either
OK or Cancel.

However I do not want to build the form. I want to create it within
the code.

Does anyone know how to do this?


---
Message posted from http://www.ExcelForum.com/

John Walkenbach has code to do this on his site:

http://j-walk.com/ss/excel/tips/tip76.htm

hth,

Doug

"ExcelMonkey " wrote in message
...
I want to put a temporary userform in my code. So when my code starts,
I want small a message box which comes up with three option buttons. I
want the user to be able to click the option of choice and press either
OK or Cancel.

However I do not want to build the form. I want to create it within
the code.

Does anyone know how to do this?


---
Message posted from http://www.ExcelForum.com/