Thread
:
Help modify simple existing code??
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Help modify simple existing code??
How about
Range("g3").Value = InputBox("Enter Your Initials")
Range("h3").Value = InputBox("Enter Today's Date")
Range("g3").Value = InputBox("Enter Your Initials in TWO letter format")
Range("h3") = date
--
Don Guillett
SalesAid Software
"ali" wrote in message
...
I've been using the following code to bring up 2 input boxes, 1 after
the other, to allow the user to enter data into cells i've
pre-determined.
Range("g3").Value = InputBox("Enter Your Initials")
Range("h3").Value = InputBox("Enter Today's Date")
However, in an ideal world (or an ideal forum!) I'd like only one input
box to pop up with two fields, initials and date, instead of the two as
at present.
Can anyone help please? Many thanks
---
Message posted from
http://www.ExcelForum.com/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]