I have an excel form that reguires the user to enter a range of cell
(variable in length) -- I would like them to be able to use the
end-down key combination when using the form.
the code below when run in a macro works-allowing the end down key
combination.
Set mydur = Application.InputBox(prompt:="Select duration data",
Title:="Duration", Type:=8)
but when the same code is placed in code for a form -- it will not
allow the end down key combination to be used???
thanks,
DTGvet
--
DTGvet
------------------------------------------------------------------------
DTGvet's Profile:
http://www.excelforum.com/member.php...o&userid=35445
View this thread:
http://www.excelforum.com/showthread...hreadid=552222