Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Question
Is it possible to write code for a message box so that you can have multiple questions inside the box and a yes/no checkbox way to answer
Here is a rough idea of what I would like it to look like Question1 yes n Question2 yes n Associated with each yes and no would be a check box that the user could select. Is this possible to do? If so could someone please help me with the code Thank you in advance Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Question
You want one message box that displays all the questions ? if so, no...
you'd have to use a Userform for that. -- Regards, Juan Pablo González "Ryan" wrote in message ... Is it possible to write code for a message box so that you can have multiple questions inside the box and a yes/no checkbox way to answer? Here is a rough idea of what I would like it to look like: Question1 yes no Question2 yes no Associated with each yes and no would be a check box that the user could select. Is this possible to do? If so could someone please help me with the code? Thank you in advance. Ryan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Question
I don't think this can be done with a message box, but you could certainly
create a pop-up form with an unbound text box and two check boxes. You could then set the data in the unbound box using code. You could place a second set of textbox and check boxes under that, then a third, etc. Another way might be to use a continuous form and populate it with your questions. This could be based off a query or code to limit which questions display. This method would be more flexible if the number of questions varies. If you get rolling on this idea and need help, just post more specific questions and I'm sure we can help ya out. Rick B "Ryan" wrote in message ... Is it possible to write code for a message box so that you can have multiple questions inside the box and a yes/no checkbox way to answer? Here is a rough idea of what I would like it to look like: Question1 yes no Question2 yes no Associated with each yes and no would be a check box that the user could select. Is this possible to do? If so could someone please help me with the code? Thank you in advance. Ryan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Question
You can't do it with a MsgBox, but you could either create a userform, or
put the questions on a worksheet and add a checkbox there for, or option buttons. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Ryan" wrote in message ... Is it possible to write code for a message box so that you can have multiple questions inside the box and a yes/no checkbox way to answer? Here is a rough idea of what I would like it to look like: Question1 yes no Question2 yes no Associated with each yes and no would be a check box that the user could select. Is this possible to do? If so could someone please help me with the code? Thank you in advance. Ryan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Question
Thanks for the answer. I will now create a userform. You were very helpfu
Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message box question | Excel Discussion (Misc queries) | |||
Message Box - Quick Question | Excel Discussion (Misc queries) | |||
Simple message box question | Excel Discussion (Misc queries) | |||
Simple message box question | Excel Discussion (Misc queries) | |||
message box question | Excel Programming |