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. .
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
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...