• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

pizza form & printing a collection

SkyB

New Member
Hello,

I am wondering how can I change the order form (the printing collection subroutine ?? ) in order to caption the user selection in one message box instead of sequential message boxes. .

Thanks,
SkyB
 

Attachments

  • Pizza73.xlsm
    23.8 KB · Views: 4
Code:
Sub PrintColl(ByRef coll As Collection)
Dim msg As String, v
msg = " You have selected Pizza73 with: "
For Each v In coll
  msg = msg & vbLf & v
Next v
MsgBox msg
End Sub
 
Great.
Also what settings do I need to change to be able to select two or all three options in the frame box ?

Thank you !
 
Change the options to checkboxes.
 

Attachments

  • Chandoo47192Pizza73.xlsm
    25.9 KB · Views: 12
Hello again,

I have added a few things on the previous form.
My goal now is to show the user selection and the total cost of the order.
There are a couple of issues which I don't know how to fix :
1.txtBox which records the qty of the order ( If the quantity is not numeric or >4 I would like to exist the form and send a message to the user)
2.The price is not correctly calculated for two selection.
3. I would like to have only one message box with the user selections and the total cost .
4.How the code can be improved ? It looks pretty cumbersome right now... Still a beginner in vba...

Your help is much appreciated!
 

Attachments

  • Chandoo47192Pizza73 (2).xlsm
    32.1 KB · Views: 4
Back
Top