Dim sABCD As String

sABCD = Inputbox("Input a character")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack Sons" wrote in message
...
Sorry, I forgot the subject when I mailed this post a couple of minutes
ago.
--------------------------------------------------------------------------

Hi all,

In my code I have a line like

Const sABCD As String = ","

but instead of this I want to enter the comma (or another character or
string or nothing) by means of input via a kind of box that will pop up
when
the code is executed. What code do I need?

Jack Sons
The Netherlands