View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Help modify simple existing code??

If you really want to use an InputBox, then you could ask the user to
separate the initials and todays date with a delimiter of some sort. eg
semi-colon.

If you think that at some point in the future you may be asking for more
than those two entries, you may want to create a userform.


"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/