View Full Version : [SOLVED:] Is there a more versatile Input Box?
h2whoa
02-12-2018, 04:39 AM
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?
John Wilson
02-15-2018, 04:07 AM
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 (https://www.keynotesupport.com/websites/special-characters-math-currency.shtml)
h2whoa
02-15-2018, 05:23 AM
OK, great. Thank you. Will try my hand at that! Sorry, I'm learning how to use VBA in a very piecemeal way!
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.