Screen Prompt to VBA Variable

[Dennis]

Am using XP Pro O/S with Excel 2002.

Need VBA (or is it VB?) code: (This VBA code will used in XL 1997 thru 2002)

1) to Screen-Prompt for a varaible (also how to enter text to that prompt)
2) (Including the VBA code for the "prompting box")
3) how to initialize (the variable obtained in #1) to be used later in the VBA code (note the variable will be text to be entered into a cell formula)

Thanks in Advance!!

Dennis

 

[Don Guillett]

sounds like homework.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Am using XP Pro O/S with Excel 2002.

Need VBA (or is it VB?) code: (This VBA code will used in XL 1997 thru 2002)

1) to Screen-Prompt for a varaible (also how to enter text to that prompt)
2) (Including the VBA code for the "prompting box")
3) how to initialize (the variable obtained in #1) to be used later in the

VBA code (note the variable will be text to be entered into a cell formula)

 

[dmburgess]

Actually no. I am 60 and must still attempt to make a living.

I not bad with XL but just a beginner with VBA.

My question is for an attempt to wow an interviewer for a job.

 

[Don Guillett]

1.2, 3

x=inputbox("Enter variable")

then use x somewhere else

--
Don Guillett
SalesAid Software
(e-mail address removed)

Am using XP Pro O/S with Excel 2002.

Need VBA (or is it VB?) code: (This VBA code will used in XL 1997 thru 2002)

1) to Screen-Prompt for a varaible (also how to enter text to that prompt)
2) (Including the VBA code for the "prompting box")
3) how to initialize (the variable obtained in #1) to be used later in the

VBA code (note the variable will be text to be entered into a cell formula)