LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default One click date + predefined text input.

I would like to create a button on my toolbar that once clicked inputs the
current date and 2 words.

Example:
With a cell JUST selected (not in typing/edit mode) you click this button
and it automaticlly enters typing/edit mode (f2) then goes to the next line
(alt + enter) and inputs the current date =TODAY() with a space and 2 words
"no change". All without clearing the current contents of the cell. There may
be multiple lines of text already.

Any help would be appreciated. This would shave coniderable time off my
daily Excel usage.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Input Text Upon Click Of Cell Keyrookie Excel Worksheet Functions 4 September 23rd 07 04:47 PM
Calling a Userform from a Predefined Variable [email protected] Excel Worksheet Functions 0 April 21st 07 03:44 PM
Creating a new worksheet using predefined rows Aaron Excel Worksheet Functions 2 March 28th 07 02:16 AM
reight click a cell without exiting from input mode Khoshravan Setting up and Configuration of Excel 2 April 9th 06 01:24 AM
Click on cell-calendar drops down-click on date-date fills cell. . George Setting up and Configuration of Excel 1 April 15th 05 08:22 AM


All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"