I want to create a message box that has custom options a user can select as opposed to the standard Yes/No, OK/Cancel etc. options.
I want to create a message box that has custom options a user can select as opposed to the standard Yes/No, OK/Cancel etc. options.
Hi and welcome to the forum.
In that case I'd be inclined to design your own VBA UserForm and incorporate whatever checkbox, optionbox, commandbutton..objects etc. that you need.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank you very much. I created the user form to print out a number depending on the selected option. Although the number prints the userform message box stays on the screen. Any idea how to remedy the situation?
Hi,
You need aninstruction.Please Login or Register to view this content.
Either immediately after the printing instruction in your current macro, or in the click event of a CommandButton on the form itself.
Thank you very much for the help that worked perfectly. So I want all the inputs that the user enters to be added up in the end and print out for the user (it is a cost estimate). Do you have a way that you would recommend doing this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks