Consulting

Results 1 to 3 of 3

Thread: Is there a more versatile Input Box?

  1. #1
    VBAX Regular
    Joined
    Oct 2016
    Posts
    45
    Location

    Is there a more versatile Input Box?

    Just wondering if there is a better input method than the standard InputBox? Basically, I've got a little macro to make a certain character subscript or superscript (basically a find a replace to do things like turn H2O into H2O). The only problem is that the standard InputBox doesn't seem to handle some non-standard characters. A specific example is the beta symbol (β; or, I guess, any Greek letter). So I'm wondering if there's a better way to ask for a user-defined string (like in a search box) that allows handling of these characters?

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    You can add a userform with a textbox.

    With this you should be able to use most ALT codes if NumLock is ON.

    e.g. H then ALT8322 then O.

    BETA is ALT 0223

    List of codes
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Regular
    Joined
    Oct 2016
    Posts
    45
    Location
    OK, great. Thank you. Will try my hand at that! Sorry, I'm learning how to use VBA in a very piecemeal way!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •