Screen Prompt to VBA Variable

D

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
 
D

Don Guillett

sounds like homework.

--
Don Guillett
SalesAid Software
[email protected]
Dennis said:
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
Click to expand...
VBA code (note the variable will be text to be entered into a cell formula)
 
D

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.
 
D

Don Guillett

1.2, 3

x=inputbox("Enter variable")

then use x somewhere else

--
Don Guillett
SalesAid Software
[email protected]
Dennis said:
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
Click to expand...
VBA code (note the variable will be text to be entered into a cell formula)
 
Top