Input Box within a macro
 

I would like a box to pop up while running a macro that will prompt the user
for a date or number and then take that date or number entered and place in a
specific cell on the spreadsheet.

Input Box within a macro
 

This does not validate the input but if you need validation just reply back...

Range("A1").Value = InputBox("Enter Something")
--
HTH...

Jim Thomlinson


"McCloudK" wrote:

I would like a box to pop up while running a macro that will prompt the user
for a date or number and then take that date or number entered and place in a
specific cell on the spreadsheet.

Input Box within a macro
 

Jim - couple of weeks old this post but I'm looking for the validation that
you mention :-)

I've got a userform so admin staff can enter employee details and part of
that is start/finish date. I wanted to cheat really and try and get Excel to
validate the date entered for me, rather than have to type the code, and to
that extent I've tried using DateSerial to create a date with no luck.

I was thinking about putting the date into a cell on a hidden worksheet to
validate it but it seems a little "clunky" to me. Is this the best way for me
to validate the dates entered unless I write out some lengthy validation code?

Thanks
George

McCloudK - hope you don't mind me pinching the post :-)

"Jim Thomlinson" wrote:

This does not validate the input but if you need validation just reply back...

Range("A1").Value = InputBox("Enter Something")
--
HTH...

Jim Thomlinson


"McCloudK" wrote:

I would like a box to pop up while running a macro that will prompt the user
for a date or number and then take that date or number entered and place in a
specific cell on the spreadsheet.

Input Box within a macro
 

Aha! If anyone reads this not to worry, I've managed to find the answer after
a little more digging around in this usergroup.

By using a combination of string concatenation and the IsDate() function
I've found the answer :-)

Thanks for anyone who thought about this though!

"George" wrote:

Jim - couple of weeks old this post but I'm looking for the validation that
you mention :-)

I've got a userform so admin staff can enter employee details and part of
that is start/finish date. I wanted to cheat really and try and get Excel to
validate the date entered for me, rather than have to type the code, and to
that extent I've tried using DateSerial to create a date with no luck.

I was thinking about putting the date into a cell on a hidden worksheet to
validate it but it seems a little "clunky" to me. Is this the best way for me
to validate the dates entered unless I write out some lengthy validation code?

Thanks
George

McCloudK - hope you don't mind me pinching the post :-)

"Jim Thomlinson" wrote:

This does not validate the input but if you need validation just reply back...

Range("A1").Value = InputBox("Enter Something")
--
HTH...

Jim Thomlinson


"McCloudK" wrote:

I would like a box to pop up while running a macro that will prompt the user
for a date or number and then take that date or number entered and place in a
specific cell on the spreadsheet.