ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code snippets for custom menu (https://www.excelbanter.com/excel-programming/393506-code-snippets-custom-menu.html)

Bob

Code snippets for custom menu
 
Can someone kindly point me to a website where I can find examples of code
that will allow me to create a dialog box that pops-up at the beginning of a
macro and asks the user to choose among 3 options using radio buttons?
Thanks in advance for any help in this area.

John Bundy

Code snippets for custom menu
 
I don't know about websites, but what you want is a user form, in the vba
editor right click the VBAProject in your project menu and insert userform.
This opens the form and the buttons you can use on them, just drag them on.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Bob" wrote:

Can someone kindly point me to a website where I can find examples of code
that will allow me to create a dialog box that pops-up at the beginning of a
macro and asks the user to choose among 3 options using radio buttons?
Thanks in advance for any help in this area.


Bob

Code snippets for custom menu
 
John,
Thanks for the advice.
Bob

"John Bundy" wrote:

I don't know about websites, but what you want is a user form, in the vba
editor right click the VBAProject in your project menu and insert userform.
This opens the form and the buttons you can use on them, just drag them on.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Bob" wrote:

Can someone kindly point me to a website where I can find examples of code
that will allow me to create a dialog box that pops-up at the beginning of a
macro and asks the user to choose among 3 options using radio buttons?
Thanks in advance for any help in this area.



All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com