![]() SECOND UPDATE: I've found the solution and posted it in an answer below. Unfortunately, the prompt is still missing when I run the macro on the Mac version of Excel. Prompt:="Please enter a name for the new assessment:", _ UPDATE: I've now labelled the arguments in the code like so: On Error Resume Next Is there a difference in the way the Mac version of Excel deals with VBA code, that would cause this to happen? Are the problems a result of bad coding on my part, combined with the weaker VBA support that Excel seems to have on the Mac? In this case, all that is displayed is the title 'Enter assessment name' and the text box where the user types the name. Here is an example of the code that I use to handle the InputBoxes: On Error Resume NextĪssessmentName = Application.InputBox("Please enter a name for the new assessment:", "Enter assessment name") ![]() ![]() However, for alternative ways to type this symbol in Word or Excel, please explore the remaining sections below. I've coded it under Windows, where everything works fine, but when I test it on the Mac version of Excel (the latest version, 15.24, I believe), the InputBoxes only show the title and the text box for the input data the prompt text is not shown. Using the Alt Code method for Windows, and the Shortcut for Mac, you can easily insert this symbol () anywhere on your PC or Laptop including Microsoft Word, Excel and PowerPoint. I've been building a system that will keep track of student grades, using Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |