***Combined Message box for all questions***

**[email protected]** · 10-20-2015, 06:37 AM

In the attached workbook, there are fore message box appears to get feedback to run macro.
1. Want to divide the values in the excel sheet? Y/N if yes enter the value to divide
2. Want to send mail to Mr. A…? Y/N
3. Want to send mail to Mr.B…? Y/N
4. Want to rename the sheet ? Y/N if yes enter the sheet name.

Can we make all this question in one single message box, like forms? If yes kindly help to get the code

I have mentioned sample message box in the attached workbook sheet 2

**Kaper** · 10-20-2015, 07:43 AM

Not much more than you did.
Of course you can prepare a form.
If you want a sequence of MsgBoxes - you can write a function like:

Please Login or Register  to view this content.

and then in a code have a bit shorter

Please Login or Register  to view this content.

rather then:

Please Login or Register  to view this content.

PS. Please do not attach password-protected files. It makes their processing longer.

**[email protected]** · 10-20-2015, 11:02 AM

Thanks Kaper for your input!

I have attached the excel without password.

Can any one guide me how to Cobain all this messages in form type.

Regards,

Prabhu

**Kaper** · 10-21-2015, 05:08 AM

See attached. There is a userform with first 2 questions (checkboxes) and 1 button (process).

Once Userform is called ansd user selects checkboxws and pushes process the process button code is called:

Please Login or Register  to view this content.

and then in sample procedure current values of chcekboxes are tested:

Please Login or Register  to view this content.

Combined Message box for all questions

LinkBack

Thread Tools

Rate This Thread

Display