Hi,
Having a dabble with Message Boxes. Basically, I would like to call an error if a certain combination is wrong with an additional OK button to close the message box.
Does the code go into a module??? Help
Please Login or Register to view this content.
MsgBox is a statement, not an object so it has no properties like "Value". The statement does, however, accept parameters
1st parameter is the message to displayPlease Login or Register to view this content.
2nd parameter defines the buttons & icon to display
3rd parameter is the window title
All are fully explained in Help
Last edited by cytop; 02-10-2017 at 05:49 AM.
So, how can I use the contents of a ComboBox to execute the message?
Use the Value of the ComboBox as the literal text to display.
Also you need to re-read your previous thread ("Is there an 'or' command") and correct the IF statement as posted.
Like this:
Please Login or Register to view this content.
Or this???:
Please Login or Register to view this content.
No- like post 2
and this needs changing as mentionedPlease Login or Register to view this content.
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
So the comment "Use the Value of the ComboBox as the literal text to display" - does this mean that I remove the "" marks like:
Please Login or Register to view this content.
No, I think cytop assumed you wanted to use the value of the combobox in the message box. Is that the case?
As discussed in your other thread, you need to use something like
or a variablePlease Login or Register to view this content.
You can only use the comma separated values syntax with a Select Case statement thusPlease Login or Register to view this content.
Please Login or Register to view this content.
ahh right, I'm still thinking ilke its a case,Ill try these and get back to you. Cheers
Works fine , thanks. Gonna try and develop, Cheers !!!
Another question, how can I Put the word error in the Caption Frame above dialogue box?
Please Login or Register to view this content.
If you read the help on Msgbox you'll see that the third argument is the title of the message box.
Ah yes got it, Cheers :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks