Macro to open up message box with radio button options

Hi Experts,

I need assistance I would like to be able to hit control K (macro) and then have a message box pop up that has 4 radio button options in which state , Run, Delete data, Run end of day.

Then depending which one you choose it will accomplish the task.

Thank you!

Noah

You could use a UserForm to do this.

In the attached press Ctrl+k and the form will show up. Select an option then click the 'Do it' button, a message box will pop up in this example but in reality you'd change the coding to fire your macros instead.

BSB

Thanks Badly!

this looks really Good, I'm guessing then in the back end I just put in the code to the macro that I want done under each user form. So then when I click an option it will do just that.

Wow it works fantastic !

Thank you! one more thing can you give me just some quick notes on how you built the user form, I see it in the back end so that's fine but I just need a few steps how you got the radio buttons and all.


so step 1, then step 2 ect.

I would appreciate that!

Thank you!

No problem. Simple as this...

1) Press Alt+F11 to open the VB Editor
2) Right click near the top left where it says "VBAProject (YourWorkbookNameHere)"
3) Select "Insert / UserForm"
4) A floating menu called "Toolbox" should appear. If not, select "View/Toolbox"
5) From there you can drag and drop the different control types onto the UserForm, resize, reposition etc.

Then simply a case of learning how they all work and how to program them Have fun with it.

Worth noting that in the attachment to post #2 I used a CommandButton on the form. You could (and I think this is what you were alluding to in post #3) use click or change events on each of the radio buttons so when they're selected the relevant code fires (without the need to click the 'GO' button). The reason I didn't do that is I build userforms every day and I know that humans are quite likely to click on a radio button by accident and do something they didn't want. Then you have to put everything right for them. The CommandButton is a safety net in the middle. You can even code it so a message box pops up saying "Are you sure????" before the code fires, just to be on the safe side

Shout if you have more questions.

BSB

Hi Badly,

no worries all works good, I totally understand now how it works, thanks for you help! this is really good.

Noah