Get information from user with Application.Inputbox

If you want information from a user you can use for example a UserForm, but in Mac Excel you are not able to add a UserForm to your workbook in the VBE UserInterface. You must develop in Excel for Windows or maybe Application.Inputbox is an option to use. Be aware that there is also a VBA.Inputbox but this have no option to set the datatype and not have an option to see if the Cancel button is pressed.

Below you find 3 macro examples to get a range, number and text with Application.Inputbox.

Note: if you sum the Type numbers you can specify more than one datatype, if you use 3 you can enter text or numbers for example.

2/5/23
Web design by Will Woodgate