code for a pop up box
 

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

code for a pop up box
 

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

code for a pop up box
 

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.

"Bob Phillips" schreef in bericht
...
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

code for a pop up box
 

Well, we're always pleased to hear from you Jack :-))

Bob


"Jack Sons" wrote in message
...
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.