Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!! To modify existing formula | Excel Discussion (Misc queries) | |||
Modify the existing formula | New Users to Excel | |||
How do I delete or modify an existing drop down list? | Excel Discussion (Misc queries) | |||
Modify an existing Cell formula using VBA | Excel Discussion (Misc queries) | |||
How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) |