code for a pop up box

J

Jack Sons

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
 
B

Bob Phillips

Dim sABCD As String

sABCD = Inputbox("Input a character")

--

HTH

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

Jack Sons

Bob,

Thanks.

Apparently this is one of my off days, for the second time within an hour I
have to sya
"I felt that I somehow was overlooking the obvious, now I'm sure."

Jack.
 
Top