PDA

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!