Full Version: [DumbQ - XL] Is there any way to enter your fullname in an XL wi
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
Prateek
One feature of XL that I fondly put to use is Ctrl+; (combination of control key and semicolon), and Ctrl+: (combination with colon), which inserts current date and current time respectively into an active cell. Very neat.
ow, i need a feature for inserting my name (name you register in your PC) with a single key stroke, rather than to have to type it out every time (not that i don't like my name). Would be useful in XL file where you have a column for entering your name.
Any idea?
Luceze
Hello,
You can write a simple Sub in a module in your Personal.xls and assign a shortcut key to it.
CODE
Sub EnterName()
ActiveCell = "Eric Isom"
End Sub

HTH,
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.